Excel help required - please

Man of Honour
Joined
29 Mar 2003
Posts
57,606
Location
Stoke on Trent
Here is a timesheet I'm working on - Timesheet

People log their stop and start times into the 3 columns and the total time is added on the right column.
I would now like to add up all the time in the pink column so it shows at the bottom.
I've tried a SUM command and I've tried a long winded method of +r7+r8 etc but I can't find a method that will add up that column correctly.
I can add 2 of them together but as soon as I try 3 or more the answer goes haywire.
At the moment there are only 4 figures to add up which should come to 32:45

Also in cell v47 I wanted to add a formula that would subtract v46 away from v45 and multiply it by 7.5 but I can't do that either.

Any suggestions?

Thanks
 
Here is an updated timesheet I'm working on - Timesheet

My problem is that I want to subtract y15 from w15 but as you can see one of them is a number and the other is the time [hh]:00

Is there any way of converting one or the other so that I can subtract them even if I use another cell to do it?
 
Back
Top Bottom