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.

Solved Solved
0 17 1,037
1 ACCEPTED SOLUTION

Worked Perfectly, thank you @Steve

View solution in original post

17 REPLIES 17
Top Labels in this Space