Excel 2000 - Time Calculations.

  • Thread starter Thread starter Ransom
  • Start date Start date
R

Ransom

How can I calculate the hours and fractions of hours
between two time inputs in two fields of Excel? For
instance, I have 9:00 AM and 6:15 PM on two fields of a
timecard, and I want it to return 9.25.

Many thanks for any help you can give me.

Ransom
 
Ransom,

Try a formula like

=(end_time - start_time) * 24


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Hi,

If you have start time in column A and end time in column
B, the calculation you need would be like this:

=HOUR(B1-A1) & "." & (MINUTE(B1-A1)/60)*100

Give that a go.

:-)

Rob
 
Back
Top