Forum Discussion
Excel Timestamp Formula
I'm trying to subtract timestamps in Excel that are formatted as "day hour/minute/time." The problem is that Excel doesn't recognize it as a date or time, so I can't extract out the time calculation...
If ignore dates (all timestamps are for the same date) that could be
=RIGHT(A2,8)-RIGHT(A1,8)
and format resulting cell as time
If add days difference when
=RIGHT(A2,8)-RIGHT(A1,8)+LEFT(A2,2)-LEFT(A1,2)
and format the result as elapsed time, i.e. [hh]:mm:ss