Time format for workschedule
 

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?

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?