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! Go to Solution.
Worked Perfectly, thank you @Steve
User | Count |
---|---|
35 | |
31 | |
30 | |
19 | |
17 |