Forum Discussion
Solved
Compute elapsed time
I have a spreadsheet of charging time for my Jeep. I would like to calculate the duration of the charging period but am having problems coming up with a formula that would work. It would have to...
Ah you have Excel 2013. That doesn't have access to these newer functions.
By Date-Time combined format I just mean put the whole date AND time into a single cell:
Start End Total
6/26/2026 16:03 6/27/2026 04:06 =B5-A5
the alternative using your current format might be something like:
G5 = HOUR ( D5+TIME(E5,F5,0) - A5 - TIME(B5,C5,0) )
H5 = MINUTE ( D5+TIME(E5,F5,0) - A5 - TIME(B5,C5,0) )
Can you show me the simple Date-Time combined format solution?