Wrote:
Hi Jesse,

You need to multiply the time by 24 to turn it into a decimal.

e.g. Total Time Worked + OT =(SUM(H10:H23)+K24)*24

7:40 becomes 7.67

Make sure you format the cells to number with 2dp.

HTH - David


david it all works execpt when you get to the total below is the
example i used to test :
Time Worked (hrs)

sat 0.00 =((F10-C10)-G10)*24
sun 0.00
mon 1.00
tue 7.67
wed 7.25
thurs7.75
fri 0.00
sat 0.00
sun 0.00
mon 0.00
tue0.00
wed7.67
thurs7.50
fri 7.33 =((F23-C23)-G23)*24

Total Time Worked +toil taken 1108.00 =(SUM(H10:H23)+K24)*24
this includes no toil.
i have added a text version TD for you to look at for referance
Regards,
Jesse


+-------------------------------------------------------------------+
|Filename: 200805.txt |
|Download: http://www.excelforum.com/attachment.php?postid=3787 |
+-------------------------------------------------------------------+

--
Jesse_Norris
------------------------------------------------------------------------
Jesse_Norris's Profile: http://www.excelforum.com/member.php...o&userid=25546
View this thread: http://www.excelforum.com/showthread...hreadid=401382