J
Julie Owen
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?
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?