+ Reply to Thread
Results 1 to 5 of 5

timestamp + 6hours

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    07-04-2014
    Location
    Netherlands
    MS-Off Ver
    all
    Posts
    121

    timestamp + 6hours

    If my shift times are 9:00 till 17:00 hr and I need to work 6 hours on this help, how to count the time futher to the next day?


    A1
    01-01-01-2014 12:00:00  
    =B1+"6:00"
    this gives
    01-01-01-2014 18:00:00

    Since I quit at 17:00 i need to work 1 hour left the next day.
    Output must be:

    01-01-01-2014 12:00:00
    =B1+"6:00"
    02-01-01-2014 10:00:00

  2. #2
    Forum Contributor guitarsweety's Avatar
    Join Date
    10-30-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2010
    Posts
    188

    Re: timestamp + 6hours

    Try this:
    Formula: copy to clipboard
    =B1+TIME(6,0,0)
    and change the cell formats

  3. #3
    Forum Contributor
    Join Date
    07-04-2014
    Location
    Netherlands
    MS-Off Ver
    all
    Posts
    121

    Re: timestamp + 6hours

    I think I need an If check but don't know well how to implement it.
    Something like: hour = +6 and time is <17:00 hr then >nextday + timeleft

  4. #4
    Forum Contributor
    Join Date
    07-04-2014
    Location
    Netherlands
    MS-Off Ver
    all
    Posts
    121

    Re: timestamp + 6hours

    Its gives me the right value:
    01-01-01-2014 12:00:00
    =B1+"6:00"
    Result: 01-01-01-2014 18:00:00

    But since the I quit @ 17:00 i have one hour left the next day.

  5. #5
    Forum Contributor
    Join Date
    07-04-2014
    Location
    Netherlands
    MS-Off Ver
    all
    Posts
    121

    Re: timestamp + 6hours

    Anyone with some input? How can I work this out?
    I would like to stop the time at the end @ 17:00 o'clock and paste it trough to the next working day.

+ 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: 18
    Last Post: 02-24-2014, 06:13 PM
  2. [SOLVED] Timestamp for any changes in row from A:S
    By ld2x07 in forum Excel General
    Replies: 7
    Last Post: 06-14-2013, 11:20 AM
  3. [SOLVED] Formula: To calculate duration between two times, if duration is over 6hours subtract 30mi
    By MattBarnes7 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-11-2013, 03:22 PM
  4. When a timestamp doesn't behave as a timestamp
    By mredekopp in forum Excel General
    Replies: 3
    Last Post: 03-07-2011, 03:39 PM
  5. is there a way to timestamp
    By 173 in forum Excel General
    Replies: 2
    Last Post: 12-28-2008, 03:45 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