subtract times

[mp]

How to get time difference in hours and fractions of hours?

example 3 columns in a spread sheet
Col A and B formated as "Time"
Col C formatted as Custom "h:mm" produces result 0:20 in example below
how to format so as to produce result 0.3333?
I tried formatting as "h" but it then produces 0
formatting as 0.00 produces 0.01 - no clue how it comes up with that one?

Col A Col B Col C
Start Time End Time Elapsed
2:50 PM 3:10 PM = B-A

thanks
mark

 

[Joe User]

How to get time difference in hours and fractions of hours? [....]
Col A Col B Col C
Start Time End Time Elapsed
2:50 PM 3:10 PM = B-A

=(B2-A2)*24

formatted as Number with some number of decimal places.

Time and dates are stored as days and fraction of days.


----- original message -----

 

[Per Jessen]

Hi Mark

Use this formula:

=MINUTE(B1-A1)/60

and format the cell as general.

Note: This formula will only work when B-A <=60

Hopes this helps.
....
Per

 

[mp]

How to get time difference in hours and fractions of hours? [....]
Col A Col B Col C
Start Time End Time Elapsed
2:50 PM 3:10 PM = B-A

=(B2-A2)*24

formatted as Number with some number of decimal places.

Time and dates are stored as days and fraction of days.

Thanks much! that works
mark

 

[mp]

Thanks Per
Joe's also worked and should work for any amt, not just <60

Hi Mark

Use this formula:

=MINUTE(B1-A1)/60

and format the cell as general.

Note: This formula will only work when B-A <=60

Hopes this helps.
....
Per