Shorthand Time Formats (HH.MM.SS)

Abbreviation

Returns (Edit 20)

Returns (Edit 23)

=

The current time

The current time

h

0h.00.00

0h:00:00

hh

hh.00.00

hh:00:00

hmm

0h.mm.00

0h:mm:00

hhmm

hh.mm.00

hh:mm:00

hhmms

hh.mm.0s

hh:mm:0s

hhmmss

hh.mm.ss

hh:mm:ss

hh.mm.ss
or
hh:mm:ss

If hh or mm or ss are single digits, zero (0) is inserted before the digit. If hh or mm or ss are omitted, they are set to 00—for example, .2. becomes 00.02.00

+ or - hh.mm.ss
or
+ or - hh:mm:ss

Same rules as above except that the time is added or subtracted from the current time—for example, +1.5 is 1 hour and 5 minutes from now


Copyright © 2008 CA. All rights reserved.