+ Reply to Thread
Results 1 to 8 of 8

Help on a work schedule

  1. #1
    Registered User
    Join Date
    08-19-2009
    Location
    Joplin, Missouri
    MS-Off Ver
    Excel 2003
    Posts
    4

    Help on a work schedule

    I am in need of help, I have been tasked with creating a new work schedule, and I am at my wits end. I would like it to add the total hours worked for each person, each day in the green cells, next to each daily schedule. If I have to change the time format I am ok with that, I just don't know enough to know what I need to do.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    02-27-2008
    Posts
    134

    Re: Help on a work schedule

    I summed up the hours above the date (filled in green)

    Is this what you are wanting?
    Attached Files Attached Files

  3. #3
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Help on a work schedule

    Assuming your time input cells are formatted correctly ( I would use 24 hour time for clarity: e.g. 17:00 vs. 5:00 pm but it's your choice).

    This formula will calculate the hours worked:
    =(B13-B12)*24
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-19-2009
    Location
    Joplin, Missouri
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Help on a work schedule

    I would love to use military time, but the Boss will not allow it. Thank you guys for trying Palmetto you are on the right track I just need it to work on a AM/PM schedule

  5. #5
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Help on a work schedule

    Palmetto's formula will work for you even if you use AM/PM as long as it is formatted as time and not text. However yours are formatted as (text 6a is not a valid time format). If you go through the trouble of converting them all (e.g. 6a to 6:00 AM), then starting in C12
    Please Login or Register  to view this content.
    That can be dragged and copied to all your green cells. Does that work for you.
    Last edited by ChemistB; 08-19-2009 at 04:35 PM.
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  6. #6
    Registered User
    Join Date
    08-19-2009
    Location
    Joplin, Missouri
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Help on a work schedule

    excellent work and great help guys, one last question what formula would I use to add the total hours scheduled for that week for each person?

  7. #7
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Help on a work schedule

    Well, your equation
    Please Login or Register  to view this content.
    works perfectly well.

    Or
    Please Login or Register  to view this content.
    Entered as an array (CNTRL SHFT ENTER)

    Or
    Please Login or Register  to view this content.
    Any of these work for you?

  8. #8
    Registered User
    Join Date
    08-19-2009
    Location
    Joplin, Missouri
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Help on a work schedule

    I want to thank everyone for the help I was able to make the schedule with your help

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1