converting time to decimal

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

Guest

I am trying to create a timesheet which shows start time and end time in standard time format (8:00 AM) then calculates the total time worked as elapsed time (8:00 AM - 9:15 AM would equal 1:15 (1 hour and 15 minutes) BUT I would like the 1:15 to appear as a decimal 1.25 (hours).

Anybody know the formula or conversion I need to accomplish this?
 
One way:

= (A2 - A1) * 24

XL stores times as fractional days, so to get fractional hours, multiply
by 24.
 
Back
Top