Time format for workschedule

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
(e-mail address removed)
 
Back
Top