Custom time format

  • Thread starter Thread starter Horatio J. Bilge
  • Start date Start date
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
 
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...
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Bar - display of content 4
please help.is it possible re-edit macro to convert text like1530-2200 to time format automatically? 1
Subtract times? 2
Creating uniform time format from multiple formats 1
Time formatting in Excel 2003 2
Length of time from date/time custom format 2
Date Time formatting problem 7
Issue with a macro 18

Back
Top