Results 1 to 3 of 3

Thread: Need formula to obtain Date for date/time range 6:00:00am - 5:59:59am

  1. #1

    Question Need formula to obtain Date for date/time range 6:00:00am - 5:59:59am



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I'm looking for a formula to extract the date to Column G (number). The date/time is in Column D in the format "m/d/yyyy h:mm" (Ex: 9/1/2012 12:01:21 AM).

    The date will start at 6:00:00am and end at 5:59:59am the next day.

    For example, 9/3/2012 12:01:21 AM or 9/3/2012 5:59:21 AM should return date 2.

    Thank you.

  2. #2
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    121
    Articles
    0
    Excel Version
    Microsoft Excel 2013
    To return the day (as a number) as you describe, try this:

    Code:
    =DAY(D2-TIME(6,0,0))

  3. #3

    Quote Originally Posted by CheshireCat View Post
    To return the day (as a number) as you describe, try this:

    Code:
    =DAY(D2-TIME(6,0,0))
    Thank you!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •