Formatting cells with time

  • Thread starter Thread starter Charlie''s Word VBA questions
  • Start date Start date
C

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.
 
Try the following custom format:
[<0.00694]m:ss;[<0.04166666]mm:ss;[h]:mm:ss

Regards,
Fred.

"Charlie''s Word VBA questions"
 
Hey, that's great. Many thanks.

Fred Smith said:
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.
Click to expand...
Click to expand...
 
Back
Top