Skip to content

Calculating Elapsed Time

How to calculate and track elapsed time.

We receive lots of questions about tracking elapsed time, which confuses everyone at first. If you’re working within the same 24 hour time period, you can use the simple expression

[endtime] – [starttime]

to return the number of hours and minutes spent on a specific task. 

When you’re tracking time that extends into the next day, meaning endtime extends past midnight, use the expression

1 + [endtime] – [starttime]

About this author