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

M

Mike

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
 
R

Ragdyer

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
 
Top