+ Reply to Thread
Results 1 to 4 of 4

How to add days and hours

  1. #1
    Registered User
    Join Date
    07-04-2015
    Location
    Nevada
    MS-Off Ver
    MS OFFICE 365
    Posts
    43

    How to add days and hours

    I have a cell with the following in it.
    1/6/16 18:00
    This is the date and the military time of 6pm. This is the day and time our crew starts work.
    I would like to add in the cell below it 4 days and have the time be 06:00 which is their next work schedule. They alternate between days and night shifts, every 4 or 5 days. They are 12 hr shifts starting at either 6 am or 6 pm.

    1/6/16 18:00
    1/10/16 6:00

    I can get the days to add but how would I get it to say 6 am instead of 18:00?

    I don't know if this can be done, so however you can help would be great. Thank you.

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: How to add days and hours

    Try

    =INT(A1+4)+"6:00:00"

  3. #3
    Registered User
    Join Date
    07-04-2015
    Location
    Nevada
    MS-Off Ver
    MS OFFICE 365
    Posts
    43

    Re: How to add days and hours

    That worked perfect. Thank you so much.

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: How to add days and hours

    You're welcome.

+ 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. Replies: 2
    Last Post: 07-08-2014, 07:00 PM
  2. Work Schedule that calculates hours, lunches, days off and vacation days
    By tameronstarr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-12-2014, 12:06 PM
  3. [SOLVED] Function or macro to convert string with weeks, days, hours, minutes to Hours
    By kknb0800 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2012, 11:35 AM
  4. Convert days -> Years, Months, Days, Hours, Minutes, Seconds
    By brharrii in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-06-2012, 06:44 PM
  5. Replies: 0
    Last Post: 04-07-2011, 01:46 AM
  6. Converting hours to 8 hour days, 31 day limit? Formula blows up at 256 hours..
    By krfarmer in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-25-2010, 05:21 AM
  7. [SOLVED] Problem converting Hours to Days, Hours, Minutes
    By Zyzzx in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-24-2005, 12:05 PM

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