subtract times

  • Thread starter Thread starter mp
  • Start date Start date
M

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
 
mp said:
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
Click to expand...

=(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 -----
 
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
 
Joe User said:
mp said:
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
Click to expand...

=(B2-A2)*24

formatted as Number with some number of decimal places.

Time and dates are stored as days and fraction of days.
Click to expand...
Thanks much! that works
mark
 
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
 
Back
Top