time format

[oldLearner57]

hi community

what is the two semi-colon significant for this time format

h:mm;;

can anybody kindly enlighten ??

10s community for the kind assistance

 

[Sheeloo]

Here is the description from Help
"You can specify up to four sections of format codes. The format codes,
separated by semicolons, define the formats for positive numbers, negative
numbers, zero values, and text, in that order. If you specify only two
sections, the first is used for positive numbers and zeros, and the second is
used for negative numbers. If you specify only one section, it is used for
all numbers. If you skip a section, include the ending semicolon for that
section."

 

[ShaneDevenshire]

Hi,

Actually, there is generally no reason for using the semi colons in a time
format. So usually it would simply be h:mm

 

[oldLearner57]

10s for the tips, much appreciated!

 

[oldLearner57]

10s! much appreciated!
--
oldLearner57

Hi,

Actually, there is generally no reason for using the semi colons in a time
format. So usually it would simply be h:mm

 

[David Biddulph]

Isn't the difference that the 2 semi-colons give a blank for a zero content
in the cell, whereas with just hh:mm instead of hh:mm;; you would get 00:00
for a zero?

 

[Sandy Mann]

Isn't the difference that the 2 semi-colons give a blank for a zero
content in the cell,

and negative times.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk