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
IFS(
([Finish]-[Start])<="008:00:00",
"000:00:00",
([Finish]-[Start])>"008:00:00",
([Finish]-[Start])-"008:00:00"
)
MAX( LIST(
"000:00:00" ,
[Finish] - [Start] - "008:00:00"
) )
I was waiting for a moment to use it
Thanks, it's working two 🕝
Thanks for your support
Thanks 🙏 its working perfectly
Thanks again
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |