converting time to decimal

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?
 
J

JE McGimpsey

One way:

= (A2 - A1) * 24

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating Elapsed Time 2
Decimal to Time Format. 5
Sum Time 6
Converting Hours:Minutes to Decimal 2
Rounding hh:mm to nearest 15, 30, 45 minutes 4
Calculate elapsed time excluding specific timeframe 10
Converting Time to decimals and then converting decimals to time 1
elapsed time displayed as a decimal 1

Top