Ask Experts Questions for FREE Help !
Ask
    ImJack's Avatar
    ImJack Posts: 2, Reputation: 1
    New Member
    		  
    #1

    Sep 16, 2009, 12:22 PM
    Excel Total Hours Forumla Work Schedule
    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's Avatar
    ImJack Posts: 2, Reputation: 1
    New Member
    		  
    #2

    Sep 16, 2009, 12:24 PM

    [Example]
    ----------Mon ------Tues ----- Total Hours
    John ----5a-2p --- 7a-1p ---------?
    Steve ---9a-4p ----4p-9p ---------?
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #3

    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.
    Attached Files
  1. File Type: xls TimeSheet.xls (36.0 KB, 228 views)
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How to calculate total hours scheduled in excel spreadsheet [ 8 Answers ]

Hi, I am trying to create a schedule for my employees and at the same time being able to calculate (or forcast for myself) the total hours that will be worked. e.g. A B C D E F G H I... P 1 NAME MONDAY...

Work my reduced hours at work or take the payout [ 2 Answers ]

Hello, I'm not sure what to do regarding my job situation with a coworker. We both work 24 hours a week doing the same job. Our boss confronted us and said that the company was downsizing. Thus left with a decision that we either split our 24 hours and both work 12 hours a week or one could take...

Total hours from selected records [ 1 Answers ]

I have one table and the fields are start time and end time. I'm already find working hours from stime and etime. But I want total working hours for selected records. i.e I want total hours for 10 selected records.. in msacces

Loss of hours at work [ 5 Answers ]

I am currently working a hospitality job while going through college. I applied for and have received full time hours (30+) Recently a new person has been doing the schedule. This person has made it known they don't like me personally because of my lifestyle. I have never called off work and am...

View more questions Search