Calculating Hours & Minutes bewteen times in 2 different days

Hi.

I have a [Start Time] column whose value will relate to today e.g. 16.00 and a [Finish Time] column whose value will relate to tomorrow e.g. 02.10

Could someone help with an expression to calculate the different in the 2 times in the following format for example 10.10 hours.

I tried using the following suggestion from the community search (HOUR([Finish Time] - [Start Time]) * 60 + MINUTE([Finish Time] - [Start Time])) / 60 but using the examples above I am getting a -14 result.

Thank you.

Try:

((DATETIME([Finish Time]) + 1) - DATETIME([Start Time]))
2 Likes

Worked Perfectly, thank you @Steve

2 Likes