Being as your luch is paid time don't subtract it:

=IF((F13-C13)*248,8,(F13-C13)*24)

or perhaps:

=MIN((F13-C13)*24,8)

Although you may want to prevent the result showing until data is entered:

=IF(COUNT(C13:F13)<4,"",IF((13-C13)*248,8,(F13-C13)*24))

or:

=IF(COUNT(C13:F13)<4,"",MIN((F13-C13)*24,8))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"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