| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time difference between two times
Hi,
How can I calculate with a formula the time difference between two times when the second time is on the next day ( the cells are formatted as time ). i.e. the difference between 17:00 today to 01:30 next day. Thank you GL |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time difference between two times
=1+B1-A1
Of course, is the cells contain date and time, it is just =B1-A1 -- David Biddulph "GL" wrote in message ... Hi, How can I calculate with a formula the time difference between two times when the second time is on the next day ( the cells are formatted as time ). i.e. the difference between 17:00 today to 01:30 next day. Thank you GL |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference between two times | Excel Discussion (Misc queries) | |||
| Difference between date and times | Excel Discussion (Misc queries) | |||
| Difference in two times over days | Excel Worksheet Functions | |||
| HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES | Excel Worksheet Functions | |||
| Difference in Times | Excel Discussion (Misc queries) | |||
Hybrid Mode
