Posts by gtza

  • Convert Date & Time As Text To Real Date & Time

    Re: Text To Date/time Format


    Quote from mikerickson;430877

    If that string is in A1,


    =DATEVALUE(A1) + TIMEVALUE(A1)


    will return the serial date/time that can be compared with NOW()



    Hi there,


    I have a similar problem, but the above solution doesn't work for me. I still get the #VALUE error when I use the DATEVALUE or TIMEVALUE commands.


    For example, I have
    [TABLE="width: 310"]

    [tr]


    [td]

    24/08/2010 11:30:00 AM

    [/td]


    [/tr]


    [/TABLE]
    in the cell, and I get the this error regardless of whether or not this stored in the 'text' or 'dd/mm/yyyy hh:mm:ss AM/PM' formats.


    I'm at a loss - help please?