ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   hh:mm:ss AND Milliseconds? (https://www.excelbanter.com/excel-discussion-misc-queries/186323-hh-mm-ss-milliseconds.html)

Lainey25

hh:mm:ss AND Milliseconds?
 
How do I re-format my cell to show hours, minutes and milliseconds? I only
seem to be able to see hh:mm:ss

Mike H

hh:mm:ss AND Milliseconds?
 
Hi,

Format as

hh:mm:ss:000

Mike

"Lainey25" wrote:

How do I re-format my cell to show hours, minutes and milliseconds? I only
seem to be able to see hh:mm:ss


Mike H

hh:mm:ss AND Milliseconds?
 
sorry that whould be

hh:mm:ss.000

Mike

"Mike H" wrote:

Hi,

Format as

hh:mm:ss:000

Mike

"Lainey25" wrote:

How do I re-format my cell to show hours, minutes and milliseconds? I only
seem to be able to see hh:mm:ss


Lainey25

hh:mm:ss AND Milliseconds?
 
Hi Mike...unfortunately this doesn't work. Is this supposed to be done
through the 'custom' option in the 'numbers' tab?

"Mike H" wrote:

Hi,

Format as

hh:mm:ss:000

Mike

"Lainey25" wrote:

How do I re-format my cell to show hours, minutes and milliseconds? I only
seem to be able to see hh:mm:ss


Lainey25

hh:mm:ss AND Milliseconds?
 
thanx...that's done it!

"Mike H" wrote:

sorry that whould be

hh:mm:ss.000

Mike

"Mike H" wrote:

Hi,

Format as

hh:mm:ss:000

Mike

"Lainey25" wrote:

How do I re-format my cell to show hours, minutes and milliseconds? I only
seem to be able to see hh:mm:ss


Mike H

hh:mm:ss AND Milliseconds?
 
Hi,

yes you apply a custom format of

hh:mm:ss.000

Mike

"Lainey25" wrote:

Hi Mike...unfortunately this doesn't work. Is this supposed to be done
through the 'custom' option in the 'numbers' tab?

"Mike H" wrote:

Hi,

Format as

hh:mm:ss:000

Mike

"Lainey25" wrote:

How do I re-format my cell to show hours, minutes and milliseconds? I only
seem to be able to see hh:mm:ss



All times are GMT +1. The time now is 05:52 PM.

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