HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Building Reports Using the Web Intelligence Java Report Panel (August 2008)

Formatting numbers and dates208
Defining a new custom format
To define a new custom format:
1. Make sure you are in Report View.
The Edit Report button is pressed in when you are working in Report View.
2. Right-click the cell(s) to which you want to apply a custom format.
3. Select Number Format.
The Number Format dialog box appears.
4. In the Format Type list, select the format category that corresponds to the data type
in the selected cell.
For example, if the selected cell displays date and time information, select Number.
The Custom check box appears.
5. Select the Custom check box.
HH:mm The hour and minutes with
leading zeros.
‘7.15 am’ with the
format:
HH:mm gives
‘07:15’
HH:mm:ss The hour, minutes, and
seconds with leading zeros.
‘7.15 am’ with the
format:
HH:mm:ss gives
‘07:15:00’
mm:ss The minutes, and seconds
with leading zeros.
‘07:15:03’ with the
format:
mm:ss gives ‘15:03’
Data Type Character Displays Example