How do I subtract end time from start time to determine duration in minutes?

dminor764

I want to subtract an end time from the start time to calculate the duration of a task in minutes. For example 4:20 - 4:12 = 8 minutes. Is this possible?

Samuel Mueller

@dminor764 Would be something like this

=(TIME([End Time]@row) - TIME([Start Time]@row)) * 24 * 60

Samuel Mueller

@dminor764 Would be something like this

=(TIME([End Time]@row) - TIME([Start Time]@row)) * 24 * 60

dminor764

Yes! Thank You! That worked perfect except for when the start time was 12:46 and the end time was 1:10, it then returned 696. Any advice for that?

Samuel Mueller

unfortunately just add AM and PM to your times, lol.

Or you could enter it in military time instead.