Adding hours on a time sheet

[Guest]

How do you add hours on a time sheet? I'm trying to come up with a spreadsheet where my employees can type in their time in's and time out's throughout the day and Excel will add them up daily and weekly. I am able to add the hours in a day but when I try to add up the hours for the week, the sum reverts back to zero once you get to 24 hours. It's almost like the computer is reading the 24 hours as one day and it won't allow me to go over that 24th hour. I also want my employees to be able to type in the actual time and not have to convert it. (For example, for 1:30 pm, they would type that in. Not 13.50.)

 

[Bob Phillips]

Format the result cell as [h]:mm and when it goes above 24 hours, it won't
roll-back to 0.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

How do you add hours on a time sheet? I'm trying to come up with a

spreadsheet where my employees can type in their time in's and time out's
throughout the day and Excel will add them up daily and weekly. I am able
to add the hours in a day but when I try to add up the hours for the week,
the sum reverts back to zero once you get to 24 hours. It's almost like the
computer is reading the 24 hours as one day and it won't allow me to go over
that 24th hour. I also want my employees to be able to type in the actual
time and not have to convert it. (For example, for 1:30 pm, they would type
that in. Not 13.50.)

 

[Norman Harker]

Hi 3throks

Re: "I also want my employees to be able to type in the actual time
and not have to convert it. (For example, for 1:30 pm, they would
type that in. Not 13.50.)"

But they can just type in 1:30 pm

You might format the cell differently to show 13:30 To do that format
hh:mm. The entry of 1:30 pm will then get displayed as 13:30

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.