Microsoft Excel Formula "IF" to create a timesheet
First you need to tell us what's in d13, c13, e13 and f13.
Regards,
Fred.
"reagolly" wrote in message
...
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
|