Thread
:
Time formulas
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
Time formulas
=(MOD(C7-C6,1)+MOD(C9-C8,1))*24
Format the cell as General or number. This will take care of either set
crossing midnight.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Blazingsaddles" wrote in message
...
Here is my timesheet:
c6: 11:00 pm
c7: 12:00 am
c8: 7:00 am
c9: 3:00 pm
c10: (Actual hours worked)
If I use the formula: =IF(C6C7,C7+1-C6,C7-C6)*24
I can get the time for c6/c7, but what formula do I use to not only get
the
hours from c6/c7, but also from c8/c9 - to get the total of 9 hours in
c10?
Thanks, I appreciate any help.
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann