Forum Discussion

KelvinUK's avatar
KelvinUK
Copper Contributor
Jun 27, 2021
Solved

Split date time cell value

This should be simple, but my stroke affected brain just cannot work it out!!   I have a column of cells that I have formatted a ddmmyyy hh:mm. However, I need to extract the time into a separate c...
excel
Formulas and Functions
  • NikolinoDE's avatar
    NikolinoDE
    Jun 27, 2021

    KelvinUK 

    Here is a small example, inserted in the file. At the same time, additional suggestions for solutions and information

     

    example 2:

    =TEXT(A1,"h:mm:ss")

    examble 3:

    =TIME(TEXT(A1,"h"),TEXT(A1,"m"),TEXT(A1,"s"))

    examble 4:

    =TIME(HOUR(A1),MINUTE(A1),SECOND(A1))

     

    Additional Information:

    HOUR function

     

    Nikolino

    I know I don't know (Socrates)

    * Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.

NikolinoDE's avatar
NikolinoDE
Gold Contributor
Jun 27, 2021

KelvinUK 

Here is a small example, inserted in the file. At the same time, additional suggestions for solutions and information

 

example 2:

=TEXT(A1,"h:mm:ss")

examble 3:

=TIME(TEXT(A1,"h"),TEXT(A1,"m"),TEXT(A1,"s"))

examble 4:

=TIME(HOUR(A1),MINUTE(A1),SECOND(A1))

 

Additional Information:

HOUR function

 

Nikolino

I know I don't know (Socrates)

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.

KelvinUK's avatar
KelvinUK
Copper Contributor
Jun 27, 2021

Thanks to all, now resolved NikolinoDE 

Resources