I am timekeeper at our office, and have everyone's 2 week timesheet in Excel. I have to enter their work hours in an online program, which my supervisor certifies online as well. I manually add the hours, leave and sick leave on everyone's timesheet, and give them to them to each to approve, then when my supervisor goes in to certify, he uses these to check them. I want to set these up to add the totals by week in hour format, but the hour function only works on a 24 hour clock, so 40 hours shows up as only 16 when I try to sum the cells. Is there a way to override this feature?

Hi

Format as Custom "[h]:mm"


--
(Don't use my reply address - it's spam-trap)

Arvi Laanemets


"tmking" <(E-Mail Removed)> wrote in message
news:C029AED8-1FF2-4DDB-935C-(E-Mail Removed)...
> I am timekeeper at our office, and have everyone's 2 week timesheet in
Excel. I have to enter their work hours in an online program, which my
supervisor certifies online as well. I manually add the hours, leave and
sick leave on everyone's timesheet, and give them to them to each to
approve, then when my supervisor goes in to certify, he uses these to check
them. I want to set these up to add the totals by week in hour format, but
the hour function only works on a 24 hour clock, so 40 hours shows up as
only 16 when I try to sum the cells. Is there a way to override this
feature?

Hi!
In the cell where you need to sum the hours try to format to [h]:mm
which prevent excel from rolling over at 24 Hrs.therefore you will ge
the total nbr of hours.

Rgds,
Gaftali

--
Message posted from http://www.ExcelForum.com

To get the time to roll-over 24 hours, format the cell as [hh]:mm.

--

HTH

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

"tmking" <(E-Mail Removed)> wrote in message
news:C029AED8-1FF2-4DDB-935C-(E-Mail Removed)...
> I am timekeeper at our office, and have everyone's 2 week timesheet in
Excel. I have to enter their work hours in an online program, which my
supervisor certifies online as well. I manually add the hours, leave and
sick leave on everyone's timesheet, and give them to them to each to
approve, then when my supervisor goes in to certify, he uses these to check
them. I want to set these up to add the totals by week in hour format, but
the hour function only works on a 24 hour clock, so 40 hours shows up as
only 16 when I try to sum the cells. Is there a way to override this
feature?