+ Reply to Thread
Results 1 to 4 of 4

Roster - adding RDO to time 0:00 drop down list causes error in sum of hours

Hybrid View

midgieo Roster - adding RDO to time... 08-23-2014, 11:41 PM
Yogi52o Re: Roster - adding RDO to... 08-23-2014, 11:47 PM
Yogi52o Re: Roster - adding RDO to... 08-23-2014, 11:50 PM
midgieo Re: Roster - adding RDO to... 08-24-2014, 12:01 AM
  1. 08-23-2014, 11:41 PM #1
    midgieo is offline
    Registered User
    Join Date
    08-23-2014
    Location
    New Zealand
    MS-Off Ver
    2007
    Posts
    3

    Roster - adding RDO to time 0:00 drop down list causes error in sum of hours

    Hi all,

    test rost.xlsx

    I am trying to make a roster for staff that is easy to fill in. I would like to be able to have RDO (Rostered Day Off) on the drop down list in the time schedule, however when I do select RDO from the drop down list it causes an error in the "Total Hours" and the "Total Daily House Hours" cells where the sum should be.

    I've tried everything and have been googling for hours!

    Please can anybody help?

    Thank you so much

    Midgieo
    Reply With QuoteRegister To Reply
  2. 08-23-2014, 11:47 PM #2
    Yogi52o is offline
    Registered User
    Join Date
    07-30-2011
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    83

    Re: Roster - adding RDO to time 0:00 drop down list causes error in sum of hours

    See how this treats ya.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 08-23-2014, 11:50 PM #3
    Yogi52o is offline
    Registered User
    Join Date
    07-30-2011
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    83

    Re: Roster - adding RDO to time 0:00 drop down list causes error in sum of hours

    Woops, forgot the daily totals. Try again.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 08-24-2014, 12:01 AM #4
    midgieo is offline
    Registered User
    Join Date
    08-23-2014
    Location
    New Zealand
    MS-Off Ver
    2007
    Posts
    3

    Re: Roster - adding RDO to time 0:00 drop down list causes error in sum of hours

    YOU BEAUTY! LEGEND! How did you do that???
    Thank you so so much! I'm very happy!

    Midgieo
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculating staff roster time to hours, depending on time worked.
    By cookiet in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-21-2024, 09:44 AM
  2. Run-time error '13' with drop-down list
    By Caribou2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-19-2013, 11:27 AM
  3. [SOLVED] Sum the time in hours/minutes based on selection in drop down list.
    By dkboggs in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-02-2013, 02:14 PM
  4. Formula to create roster, hours worked in 24 hour time with breaks
    By nixxiola in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-05-2010, 12:00 PM
  5. Adding shift time in a roster
    By ianmb in forum Excel General
    Replies: 8
    Last Post: 03-26-2010, 09:32 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1