Overtime duration

AppSheet AppSheet Q&A
1

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

SmartSelect_20220303-172632_AppSheet.jpg
SmartSelect_20220303-172632_AppSheet.jpg1079×1136 86.7 KB

2 
IFS(
  ([Finish]-[Start])<="008:00:00",
    "000:00:00",
  ([Finish]-[Start])>"008:00:00",
    ([Finish]-[Start])-"008:00:00"
)
1 Like
3 
MAX( LIST(
  "000:00:00" ,
  [Finish] - [Start] - "008:00:00"
) )
1 Like
4

Always another way

I was waiting for a moment to use it

3 Likes
5

Thanks :folded_hands: its working perfectly

Thanks again

1 Like
6

Thanks, it’s working two :two_thirty:

Thanks for your support

1 Like