Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    May 2013
    Posts
    59
    Thanks
    34
    Thanked 6 Times in 6 Posts

    Formula for Date/Time

    I have a developing spreadsheet that manipulates a lot of dates. In one cell I have a date in the format of 5/21/2013. In a second cell I have time in the format of 10:00 for example. I need to combine them in the format of yyyymmddhhmm then be able to add x number of minutes at various times.

    I would appreciate if anyone can show me the formula I would need. Thank you in advance
    A.

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    3,045
    Thanks
    145
    Thanked 541 Times in 516 Posts
    Hi Alouso

    see attached file.
    I'm sure you'll get some other answers.

    zeddy
    Attached Files Attached Files

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    If they are Excel Dates and times, you can just add them together and do a custom number format as:
    yyyymmddhhmm
    to display as you want it. The custom format allows the values to remain as a number which can be used for additional calculations

    You can add minutes as desired. If entered as minutes in a cell, you must convert it to days (dividing by 1440 = 24*60, the minutes in a day). Excel does all date and time calculations in units of days. If you enter the minutes as something like 0:10 (for ten minutes), excel will do the conversion for you.

    Steve

  4. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,726
    Thanks
    125
    Thanked 678 Times in 616 Posts
    Al,

    This will also work:
    Cell A1- 5/21/2013
    Cell A2- 10:00
    Cell A3- any additional minutes- ex 00:01

    Cell A4 =TEXT(A1+A2+A3,"yyyymmddhhmm")=201305211001

    Time1.jpg

    HTH,
    Maud

  5. #5
    Star Lounger
    Join Date
    May 2013
    Posts
    59
    Thanks
    34
    Thanked 6 Times in 6 Posts
    Thanks guys! I will try the solutions.

    A.

Posting Permissions

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