locked
Need assistance with a formula to convert numbers into date and time. RRS feed

  • Question

  • Hi I was hoping someone could assist with this request:

    I have a some formatting issues with a column that contains date and time. In column W, I have a date and time value that is being expressed in this format: 

    44170.9843518519

    Can someone assist with a formula that would convert these instances into a proper readable date & time format?

    Thanks.

    Wednesday, May 13, 2020 1:44 PM

All replies

  • Select the column.

    Set the number format to the custom format of

    m/d/yyyy h:mm AM/PM

    for the USA, or

    dd/mm/yyyy hh:mm

    for a more European format


    Regards, Hans Vogelaar (https://www.eileenslounge.com)

    Wednesday, May 13, 2020 2:57 PM