<< Click to Display Table of Contents >> Navigation:  Reference > Formats > PNS Print Numbers of Special types

PNS is a numeric format. The standard setting is PNS0.

PNS is used to print tables where the figures are seconds and are to be converted to hours and minutes at print time.

PNS1 causes the cells in seconds to be converted to HHH:MM:SS. For example:

3 seconds will be printed as 3

59 seconds will be printed as 59

70 seconds will be printed as 1:10

3599 seconds will be printed a 59:59

3605 seconds will be printed as 1:00:05

PNS2 causes the cells in seconds to be converted to HHH:MM. For example:

3 seconds will be printed as *

59 seconds will be printed as 1

70 seconds will be printed as 1

3599 seconds will be printed a 60

3605 seconds will be printed as 1:00

The hours can be any number up to 1,000,000.

Decimal places can be added which will represent decimal parts of seconds (PNS1) or minutes (PNS2).