Is is possible to create a custom number format that will preserve the
HH:MM:SS format, but also give me decimal seconds like this??

HH:MM:SS.SS


Thanks,
John

hh:mm:ss.0

--
Regards,
Tom Ogilvy


" wrote:

Is is possible to create a custom number format that will preserve the
HH:MM:SS format, but also give me decimal seconds like this??

HH:MM:SS.SS


Thanks,
John

On May 4, 11:07 am, wrote:
Is is possible to create a custom number format that will preserve the
HH:MM:SS format, but also give me decimal seconds like this??

HH:MM:SS.SS

Thanks,
John


[h]:mm:ss.00

I had a similar issue with this, and this corrected it. Hope it works
for you.