Posts by gtza

    Re: Text To Date/time Format

    Quote from mikerickson;430877

    If that string is in 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"]



    24/08/2010 11:30:00 AM



    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?