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.

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.

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

This did not work. Excel says "formatting error, it does not like everything
after the /

"Jacob Skaria" wrote:

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.

Did not work. the formula has an error at "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.

Pattio, don't just say "it didn't work"; think about what they were trying to
accomplish, and figure out what they did wrong. What you want is a normal
fractional display of hours - like "12.75" instead of "12:45" - and then
change the period to a colon, if you really need that. (I never heard of
that, but what the heck.) So start with a date-time stamp and work it across
to your desired value one step at a time.

For instance, the NOW() function generated "2009-05-31 18:10:43" on my PC
just now. That's the value 39964.75744 (39 964 days starting from
1900-01-01), where 0.75744 is the fraction of a day represented by 18:10:43.

Separate the time part of that timestamp by some method, say
MOD(TimeStamp,1). Now you have 0.75744.

Now multiply it by 24. That gives you 18.17859167. ROUND(time,2) is 18.18.

There's more than one way to change that to "18:18". Teethless mama was
trying to turn 18.18 into a string "18.18" and then use SUBSTITUTE to change
the '.' into ':'; he just got the functions in the wrong order. Or you can
take separate the integer and fractional parts, display them each as text and
insert your own colon between. Jacob's method started further back, using
the HOUR and MINUTE functions to pull just those parts of the time and,
again, put the colon between them; that might be the easiest way to do it,
but if he made a minor error you'll have to think about it and correct it.

If you're TRYING to think about it and can't understand what they're driving
at, you'll have to ask questions. Thinking about it part of the fun; don't
deprive yourself of it just because you're in a hurry. After all, if you
don't find it fun, it's hardly fair to ask everyone else to do it all for you.

--- "Pattio" wrote:
Did not work. the formula has an error at "00\

Hi,
In military time 1:45pm is 13:45.
No military I know of uses hundredths of an hour.

John


"Pattio" wrote in message ...
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.