Nov 06 2021 08:26 PM
Nov 06 2021 10:51 PM
Solution@SWebster95 Try it like this:
=([@[Shift End]]-[@[Shift Start]])*24
I.e. put round brackets around the subtraction. Otherwise, you deduct the End time multiplied by 24 from the Start time.
Nov 07 2021 01:25 AM
A further observation. The 0.2 (strictly speaking 0.020833) was perfectly correct as a proportion of the day. The formatting could be more helpful though. A custom number format [h]:mm will provide a meaningful display of 0:30.
Nov 07 2021 07:20 AM
Nov 07 2021 07:22 AM
Nov 06 2021 10:51 PM
Solution@SWebster95 Try it like this:
=([@[Shift End]]-[@[Shift Start]])*24
I.e. put round brackets around the subtraction. Otherwise, you deduct the End time multiplied by 24 from the Start time.