Reply to thread

Message: [QUOTE="David Biddulph, post: 3786010"] You can simplify your existing formula by changing =IF((((D13-C13)+(F13-E13))*24)>8,8,((D13-C13)+(F13-E13))*24) to =MIN(8,((D13-C13)+(F13-E13))*24) The reason that you've got 7 hours instead of 8 is that you've not given credit for the hour at lunch, which you say is paid. In the simplest form, you can just delete the content of D13 and E13 (or otherwise just add 1 to the second term in the MIN expression), but you may instead wish to define how to treat the data if the lunch break is longer than, or shorter than, 1 hour. If you want to subtract time for any excess of the lunch break beyond 1 hour, you may want =MIN(8,((F13-C13)-MAX(E13-D13-1/24,0))*24) [/QUOTE]