What is in F15? If it is the lunch start time, that will have the effect of
subtracting .5 from you hours attended, which is incorrect if a lunch break
of 45 mins or 1 hour is taken.

=HOUR(H15-E15) works out the decimal number of hours from coming in to
leaving. If F15 is say 1, or .5, it works fine, but if 12:00, it doesn't.

You may want

=(H15-E15)*24-F15

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Julie Owen" <Julie wrote in message
...
I'm trying to use a modified version of the template "Biweekly Time Sheet"
where the sheet shows the time the employee came in, how long of a lunch
was
taken and the time the employee left and the formula should return the
total
number of hours when the end time subtracts the beginning time and the
result
subtracts the lunch. When I do this using the Hour formula ie.
(=Hour(H15-E15)-F15) in which H15 is the end time, E15 is the beginning
time,
and F15 is the lunch time, the amount returned is not correct. It seems
like
the formula automatically calculates a 1/2 hour lunch taken when the total
time in the day is 8 hours. It doesn't do this for a 6 hour day--for that
day it returns the correct hour total=6 hours. Also, it seems to round
the
number returned. If the total hours worked in the day should be 8.25, it
returns 8.0. How do I get it to stop doing this?