3/10/2022 8:03:33 PM how to convert this into time only =TEXT(F2,HH:MM:SS) AM/PM

Occasional Contributor

i know i am missing something i used this before but I know I am missing something =TEXT(F2,HH:MM:SS) AM/PM in this 

1 Reply
best response confirmed by Xeryar (Occasional Contributor)


You can display the time only in the cell itself by setting the number format of the cell to hh:mm:ss AM/PM.

If you want the time in another cell, use


and apply the number format hh:mm:ss AM/PM to the cell with the formula.