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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting minutes to tenths 2
Difference between two times in seconds 1
Calculate the difference betwen two columns -two dates 3
Difference Between Two Times 5
Difference of Time 1
Subtract times? 2
Difference between dates and times 5
Grouping Time in Pivots. 2

Top