Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difference between two times | Excel Discussion (Misc queries) | |||
Difference in two times over days | Excel Worksheet Functions | |||
Calculate difference (mins) between 2 Times | Excel Worksheet Functions | |||
HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES | Excel Worksheet Functions | |||
Difference in Times | Excel Discussion (Misc queries) |