Log in

View Full Version : Excel Total Hours Forumla Work Schedule


ImJack
Sep 16, 2009, 12:22 PM
Hi, I'm having trouble figuring out how to find the total hours of a schedule for employees.

Basically, the Rows are the days of the week and the columns are names, and the times fall in the middle. The problem is the a(AM) and p(PM) are necessary because it is a 24-hour store...
[Example]
Mon Tues Total Hours
John 5a-2p 7a-1p ?
Steve 9a-4p 4p-9p ?

So what kind of formula can I use to correctly add the times, while keeping the visual a and p for the schedule to make sense to the employees?

ImJack
Sep 16, 2009, 12:24 PM
[Example]
----------Mon ------Tues ----- Total Hours
John ----5a-2p --- 7a-1p ---------?
Steve ---9a-4p ----4p-9p ---------?

JBeaucaire
Sep 16, 2009, 06:48 PM
You can't put two times in one cell like that and "simply" do any time-based math on it. Start time and end time for each cell should be in a separate cell.

Upload your sheet if you want more specific assistance. Timesheets are always a bit of a bear.