ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   hh:mm:ss.ss Number format (https://www.excelbanter.com/excel-programming/388773-hh-mm-ss-ss-number-format.html)

[email protected]

hh:mm:ss.ss Number format
 
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


Tom Ogilvy

hh:mm:ss.ss Number format
 
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



Midget

hh:mm:ss.ss Number format
 
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.



All times are GMT +1. The time now is 04:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com