Format time calculation with hours and minutes

Is there an easy way to calculate a duration from start to end displayed in hours and minutes? I've only seen mention of either/or. I've tried a few things unsuccessfully. Essentially I just want ${EndTime} - ${StartTime} in a h:mm format. So, if I have StartTime = 12:00PM and EndTime = 2:06PM, I want Duration to be 2:06, not 2.1 hours or 126 minutes.

Attachments

Thanks for you reply James. After having time to work through your spreadsheet, I realized that the calculations were step wise and not additive. The single calculation on the last row is all I needed. I appreciate your help.

No worries. If you happen to be on UTC time, this can be simplified to t2-t1 - that represents the total number of milliseconds since midnight UTC and can be used in the format-date function (you could then add/subtract the UTC offset, though this would break for times lasting longer than 24 hours).

I just updated my calculations to use Decimal Time, based on the blog post here: Dates and Time in Survey123 for ArcGIS. Occasionally the calculation is 1 minute off. When there's a 1 hour difference the Unix Time calculation correctly shows 1 hour, the Decimal Time calculation shows 59 minutes. Any suggestions?