Question
Overtime formula
HI all please assist with the formula for the below.
Duration - Formula Duration - Calculate duration between start and end time and subtract 1 hour if lunch is checked.
------------------------------
Boitumelo Segaole
------------------------------
This topic has been closed for replies.
+24Try this
[end time]-[start time]
- IF([Lunch], Hours(1), Hours(0))
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
[end time]-[start time]
- IF([Lunch], Hours(1), Hours(0))
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.