+ Reply to Thread
Results 1 to 3 of 3

Adding date when times pass midnight

  1. #1
    Registered User
    Join Date
    09-29-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    73

    Adding date when times pass midnight

    I have a set of times in chronological order with a start date for the first time. I need to have dates on each stage but I can't default this to the start date as often the times pass midnight so the date needs to be the next day if the time is less than the previous stage.

    Any help much appreciated.
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,792

    Re: Adding date when times pass midnight

    Put this in C7:

    =INT(B7)+C2+(C2<B2)

    then copy across.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    09-29-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    73

    Re: Adding date when times pass midnight

    Many thanks Pete. The calculations I was doing were unnecessarily more complicated and didn't work! Yours did. Thanks a lot.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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