Hi all, i have a column which has many different times shown in this format 00:00:00, some may show 30 mins like 00:30:00 some may show 1Hr30Mins like 01:30:00 etc there are never any seconds (just the column is formatted as time!) all these times are amounts of hours and minutes worked on certain tasks, the tasks are paid by the hour.
My problem is when i SUM the column i don't get the correct amount of hours and minutes, i would like to find out the amount of wages for the range so if the range is called WorkedTime i want to multiply it by the amount of pay to find the expected wages, lets say the wages are ?8/hr
i can custom format the cell containing the formula to [h]mm:ss and then when i use =Sum(WorkedTime) i get the correct amount of hours and minutes but i am having trouble showing the actual wage!
Any ideas?
Regards,
Simon