Forum Discussion
Calculate difference between two times over multiple days
Hi I have a generated excel report that shows day and time in this format: 2019/11/30 16:32:06 2019/12/01 08:44:15 I want to calculate the difference between the two, giving the result in h...
The formula
= periodEnd - periodStart
is perfectly correct and does take the number of days into account (your example is a period of 16hrs so will not illustrate the point). If you apply the number format
[h]:mm:ss
elapsed times will show hours in a format that may exceed 24.
- Hi Peter
Perfect. Thank you so much. Knew it had to be simple. Much appreciated.
Have a good day.
Des
