"trip_to_tokyo" wrote in message
...
You could format as Number.

This would give you, "military time" for the hours between 1000 and 2400.

For the time prior to 1000 you would not get the leading zero.

Not sure if this would be acceptable to you though.

Please hit Yes if my comments have helped.

Not really, as the times need to be graphed, and formatted as number, the
number after 59 is 60, but in minutes it is 00, so the graphs would be
wrong - Thanks for your comment though.