Extract Hour, Minute and seconds from Date Time

[Cyrus]

Can someone help me. I'm was trying to extract the Hour, Minute and Seconds using this formula.

TIME( [DATETIME] ) = HH : MM : SS

Is there a way to remove the colon (  :  ) . 

When opening the link, for example ( HH:MM:SS . pdf ) will not work.

Thank you!

[TeeSee1 · Accepted solution]

https://support.google.com/appsheet/answer/10107701?hl=en

[TeeSee1 · Accepted solution]

https://support.google.com/appsheet/answer/10107701?hl=en

[Cyrus]

Thank you! I will use this expression (TEXT("2:23 PM", "H")) and will try to concatenate it.

[Aleksi · Accepted solution]

No concatenate is needed. Just use TEXT([DATETIME],"HHMMSS")