Thread
:
Time format for workschedule
View Single Post
#
2
Nick Hodge
Posts: n/a
Lifegaurd
=(A2*24)-(A1*24)
formatted as 'general'
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS
"Lifeguard" wrote in message
...
Hi, I'm looking for some help
I'm looking to calculate timesheets, but instead of 2:15 in format of 2
hours 15 minutes, I'm looking to save as 2.25 where it's 2 hours and 0.25
hours
I would take calculations from Cell A1 as start time of 8:00 AM and Cell
A2
end time of 10:15 AM and result in Cell A3.
any suggestions?
Reply With Quote