How do I set up a time sheet in Excel?
Hi Julie,
Let A is column for Start Time , B for leave for lunch,C for come back
from lunch and D for leave at the end then add this formula in column E say
in cell E2.
=if(b2<a2,a2-b2+12+d2-c2,b2-a2+d2-c2)
Harshawardhan shastri
================================================== ===========
"Julie Holmberg" wrote:
What I need to do is have people enter the time they start, what time they
leave for lunch, come back from lunch and leave at the end of the day. I
want Excel to automatically calculate the number of hours and minutes for
each of these so that I can then add up the total number of hours and minutes
worked each day.
I am having a hard time formatting the cells (do I format them as time or
numbers?) and then whenever I try to add or subtract hours, how do you deal
with the 12:00 hour, which then seems to mess up any formulas. For example,
if someone clocks in at 7 and goes to lunch at 1:30 - how can you create a
formula where Excel will get the correct answer of 6:30 minutes worked? HELP!
|