Excel 2000 - Time Calculations.

[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

 

[Chip Pearson]

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)

 

[Rob Barnard]

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