If you have an Excel workbook containing two cells that contain a date and time and you want to know the time difference between them in days and hours, you can subtract one from the other and get the elapsed time between the two timestamps in days and hours by using a custom date and time format for the cell that will hold the results. E.g., suppose I have a spreadsheet with the following timestamps in columns A and B:
| A | B | C | |
|---|---|---|---|
| 1 | Start Time | End Time | Elapsed Time |
| 2 | 1/1/18 0:01 | 3/1/18 15:03 | |
| 3 | 2/6/18 15:18 | 2/7/18 18:07 | |
| 4 | 3/1/18 7:55 | 3/1/18 13:01 |
The cells containing the date and time have the custom format
m/d/yy h:mm.
[ More Info ]
