Duration Calculations

[Neset_Kutlug]

Hi All,

The below expression aims to calculate the duration between the shift start time and shift end time in duration. It aims to handle cases where shift start is before midnight and shift end is after midnight. Both fields are in Time column type. And the column I am building this expression into is Duration column type, that is Shift Duration.

But it returns this error; Arithmetic expression ‘([Shift Start]+[Shift End])’ has inputs of an invalid type ‘Unknown’.

IF(
[Shift End]<[Shift Start],
("00:00:00 - "[Shift Start]) + [Shift End],
[Shift End]-[Shift Start]
)

Your expertise in helping me is appreciated.

Cheers,

Neşet