Formatting cells with time

[Charlie''s Word VBA questions]

How can I create a cell format for time that will display hours, minutes and
seconds where hours may exceed 24 hours. I also want to suppress hours
and/or minutes when they are zero. For example, I want to show the following
times
28:09:30 06:15:47 00:52:34 00:00:12
as
28:09:30 6:15:47 52:34 0:12
preferably with a single custom format.

I have tried several times but have not been able to solve this.

Also, in the custom cell formats, just what do the characters [ ] and @
mean? And what are formats such as [-F400 ... ?

I really appreciate any help you can offer.

 

[Mike H]

Use a custom format of

[hh]:mm:ss

Mike

 

[Fred Smith]

Try the following custom format:
[<0.00694]m:ss;[<0.04166666]mm:ss;[h]:mm:ss

Regards,
Fred.

"Charlie''s Word VBA questions"

 

[Charlie''s Word VBA questions]

Hey, that's great. Many thanks.

Try the following custom format:
[<0.00694]m:ss;[<0.04166666]mm:ss;[h]:mm:ss

Regards,
Fred.

"Charlie''s Word VBA questions"

How can I create a cell format for time that will display hours, minutes
and
seconds where hours may exceed 24 hours. I also want to suppress hours
and/or minutes when they are zero. For example, I want to show the
following
times
28:09:30 06:15:47 00:52:34 00:00:12
as
28:09:30 6:15:47 52:34 0:12
preferably with a single custom format.

I have tried several times but have not been able to solve this.

Also, in the custom cell formats, just what do the characters [ ] and @
mean? And what are formats such as [-F400 ... ?

I really appreciate any help you can offer.