=TEXT(SUBSTITUTE(A1*24,".",""),"00\:00")


"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.