I used the following formula to create a timehseet. I work from 8:30 to 4:30
with an hour paid lunch from 11:30 to 12:30. This formula only gives me 7
hours. How can I change the formula to give me 8 hours?
=IF((((D13-C13)+(F13-E13))*24)8,8,((D13-C13)+(F13-E13))*24)
--
reagolly