How to remove am pm from excel timestamp?

[idpope]

I am trying to change 0:00:20 to 20 seconds.

The(HH:MM:SS)format results in 12:00:20 AM.

How do I change this to 20 seconds (without the AM).

 

[bobhc]

Good day idpope


In number I choose custom and in type I put ss and that did the trick, I am using 2010

 

[idpope]

Thanks.

But that does not work with varying time values that may include hours, minutes and seconds.

Using the hh:mm:ss format results in values that end with AM or PM.

Still need help.

 

[NARAYANK991]

Hi ,


Try this :


=TEXT(A1,"ss")+0


where A1 has the time value. Format the cell where this formula is entered as General or Number.


Narayan

 

[SirJB7]

Hi, idpope!


Try this in B1, shorter and simpler:

=SECOND(A1)

No matter if A1 is numeric and formatted as time or if it is text.


Regards!