+ Reply to Thread
Results 1 to 2 of 2

Changing Date when Time goes from 11:50PM to 12:00AM

  1. #1
    Registered User
    Join Date
    12-18-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    1

    Changing Date when Time goes from 11:50PM to 12:00AM

    Hi...I need Excel formula for the following problem:
    Cell 1 = A date
    Cell 2 = A time
    Cell 3 = Required Formula
    Cell 4 = Calculated Time using a formula

    If Cell 1 = 01/12/2012 (01 Dec 2012 - UK style), Cell 2 = 11:50PM, Cell 4 = 12:00AM then I want Cell 3 value to become 02/12/2012 (02 Dec 2012) and If Cell 4 = 11:59PM then Cell 3 should stay as Cell 1

    Regards
    Ben

  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,731

    Re: Changing Date when Time goes from 11:50PM to 12:00AM

    Put this in Cell 3:

    =Cell 1 + (Cell 4 = INT(Cell 4))

    Substitute appropriate cell references for Cell 1 and Cell 4

    Hope this helps.

    Pete

+ 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