subtract times
 

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

subtract times
 

"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

subtract times
 

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

subtract times
 

"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

subtract times
 

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