+ Reply to Thread
Results 1 to 5 of 5

Problem adding hours/time in scheduling sheet

  1. #1
    Registered User
    Join Date
    05-29-2014
    Posts
    2

    Problem adding hours/time in scheduling sheet

    So I'm having a problem trying to make this scheduling sheet..
    What I did was row a would be the employee list then b,c,d and so on are mon-sun
    Originally in b1 I would put like 9am-5pm and c1 8-4 and so on and in row i I put the total and added a sum function but somehow it wasn't able to calculate.
    So then I redid the whole thing this time in row b1 i put 9am and c1 5pm and so on and again I put the total and added the function and it still came out wrong..
    If there's anyone here that could help me..there are no words to express my gratitude

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Problem adding hours/time in scheduling sheet

    Hi
    please post a sample sheet, there could be many reasons for which your calculation is wrong

  3. #3
    Registered User
    Join Date
    05-29-2014
    Posts
    2

    Re: Problem adding hours/time in scheduling sheet

    hi,

    i posted an example above.
    again, thank you so much.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    04-24-2015
    Location
    Arizona
    MS-Off Ver
    2013
    Posts
    10

    Re: Problem adding hours/time in scheduling sheet

    I am new but the first thing you need to do is use military hours 9:00:00 AM 13:00.00 PM - That should get you started on the right track.

  5. #5
    Registered User
    Join Date
    03-12-2015
    Location
    UK
    MS-Off Ver
    2013 & 2010
    Posts
    27

    Re: Problem adding hours/time in scheduling sheet

    I changed it a little - is this format any use? Workbook2.xls

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Adding hours to start time - Business hours/holidays/weekends
    By Thunderer in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-21-2014, 01:09 PM
  2. [SOLVED] Time Sheet Problem: Hours will not calcuate correctly if over 12 hours
    By JokesterX in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-23-2014, 02:13 AM
  3. formula for adding up hours on a time sheet
    By awebb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-12-2013, 10:06 AM
  4. Replies: 7
    Last Post: 03-31-2013, 03:09 PM
  5. Time scheduling problem
    By jtucker in forum Excel General
    Replies: 1
    Last Post: 09-02-2009, 06:57 AM

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