Custom time format

H

Horatio J. Bilge

I would like to use a single format for a couple of situations.

"12:00:55.99 AM" should return ":55.99"
Currently I am using "\:ss.00"

"12:01:55.99 AM should return "1:55.99"
Currently I am using "[m]:ss.00"


Is there a single format that I can use for both of these situations?

Thanks,
Horatio
 
D

Dave Peterson

How about:

[>0.000694444444444444][m]:ss.00;\:ss.00

0.000694444444444444 = 1/24/60 = 1 minute


Horatio J. Bilge said:
I would like to use a single format for a couple of situations.

"12:00:55.99 AM" should return ":55.99"
Currently I am using "\:ss.00"

"12:01:55.99 AM should return "1:55.99"
Currently I am using "[m]:ss.00"

Is there a single format that I can use for both of these situations?

Thanks,
Horatio
Click to expand...
 
H

Horatio J. Bilge

Thanks for the tip. It worked great.
~ Horatio


Dave Peterson said:
How about:

[>0.000694444444444444][m]:ss.00;\:ss.00

0.000694444444444444 = 1/24/60 = 1 minute


Horatio J. Bilge said:
I would like to use a single format for a couple of situations.

"12:00:55.99 AM" should return ":55.99"
Currently I am using "\:ss.00"

"12:01:55.99 AM should return "1:55.99"
Currently I am using "[m]:ss.00"

Is there a single format that I can use for both of these situations?

Thanks,
Horatio
Click to expand...
Click to expand...
 
Top