Thread
:
How do I set up a time sheet in Excel?
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_2_]
external usenet poster
Posts: 964
How do I set up a time sheet in Excel?
Just subtract and format as hh:mm
--
Regards,
Peo Sjoblom
"Julie Holmberg" <Julie
wrote in message
...
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!
Reply With Quote
Peo Sjoblom[_2_]
View Public Profile
Find all posts by Peo Sjoblom[_2_]