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" wrote:
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 -----

"mp" wrote in message
...

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" <joeu2004 wrote in message
...
"mp" wrote:
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

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

On 2 Apr., 00:41, "mp" wrote:
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

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

"Per Jessen" wrote in 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

On 2 Apr., 00:41, "mp" wrote:
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