Suppose A1 is having time formated as time.

Try and feedback the below

=TEXT(HOUR(A1),"00")&TEXT(MINUTE(A1)/0.6,"00")

If this post helps click Yes
---------------
Jacob Skaria


"Pattio" wrote:

I have reviewed all the topics on setting up military time but have yet to
find how to set up the minutes in 100's. Example: I need the time to show
13:75 or 1:45 standard time. I can set up the military hours but not the
minutes to show in 100's. How do I do that? It should show 13:75 for 1:45 or
06:25 for 6:15.