SOLVED

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)
Solution

@Xeryar 

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

=MOD(F2,1)

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