Overtime duration

[Husain82]

I have a transportation business and i want to calculate overtime hours above 8 hours. So I have the following equation that i want to insert in the appsheet. Basically i want a formula to say that any difference between end time and start time if less or equal than 8 hours then my result should be zero, otherwise if its more than 8 hours then my result should be anything above 8 hours

 

[SkrOYC]

IFS(
  ([Finish]-[Start])<="008:00:00",
    "000:00:00",
  ([Finish]-[Start])>"008:00:00",
    ([Finish]-[Start])-"008:00:00"
)

[Marc_Dillon]

MAX( LIST(
  "000:00:00" ,
  [Finish] - [Start] - "008:00:00"
) )

[SkrOYC]

Always another way

I was waiting for a moment to use it

[Husain82]

Thanks, it's working two 🕝 

Thanks for your support

[Husain82]

Thanks 🙏 its working perfectly

Thanks again