Time Format

[Matt_Chelmsford]

Hi all,

I am trying to set a format to hhh:mm:ss

Unfortunately, it will only let me set hours in double numbers and I need to show my hours in treble numbers.

Any idea?

Thanks for any help given

Regards

Matthew

 

[FormR]

Hi, try a custom format of:

[hhh]:mm:ss

 

[R Pelle]

Try formatting e.g. 12:01:15 as [hhh]:mm:ss instead of the normal hh:mm:ss

 

[Special-K99]

How will hours enter 3 figures?
Are you summing hours to produce a 3 digit hour number?
If so just add the times up, once hours goes into 3 figures it displays as three figures.

 

[Matt_Chelmsford]

Thanks the [hhh] works a treat!