How to calcuate the difference between two times in tenths of a mi
 

I need to calculate the difference between two times and have the result
displayed in hours and tenths of the remaining minutes.

Example 1:
Time 1: Time 2: Result:
4:00 pm 8:30 pm 4.5

Example 2:
Time 1: Time 2: Result:
6:00 pm 10:45 pm 4.75

How to calcuate the difference between two times in tenths of a mi
 

Time1 in Column A - Time2 in ColumnB,
Format ColumnC to General or Number,

Try this in C1, and copy down as needed.

The MOD() function is used so that your times can cross midnight and still
calculate correctly.

=MOD(B1-A1,1)*24


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mike" wrote in message
...
I need to calculate the difference between two times and have the result
displayed in hours and tenths of the remaining minutes.

Example 1:
Time 1: Time 2: Result:
4:00 pm 8:30 pm 4.5

Example 2:
Time 1: Time 2: Result:
6:00 pm 10:45 pm 4.75