PC Review
Home Forums Reviews Articles Register
Member Login:

PC Review > Forums > Newsgroups > Microsoft Excel > Microsoft Excel Discussion > Display time to the milliseconds

Reply
Thread Tools Rate Thread

Display time to the milliseconds

 
 
Patrick C. Simonds
Guest
Posts: n/a
 
      29th Oct 2008
Is there any way to format a cell to display time to the millisecond?
 
Reply With Quote
 
 
 
 
Peo Sjoblom
Guest
Posts: n/a
 
      29th Oct 2008
hh:mm:ss.000




--


Regards,


Peo Sjoblom

"Patrick C. Simonds" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Is there any way to format a cell to display time to the millisecond?
 
Reply With Quote
 
Bernard Liengme
Guest
Posts: n/a
 
      29th Oct 2008
Peo,
What am I doing wrong?
Cell has =TIME(3,4,5.125) and is formatted as hh:mm:ss.000 but displays
3:04:05.000
Thanks
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> hh:mm:ss.000
>
>
>
>
> --
>
>
> Regards,
>
>
> Peo Sjoblom
>
> "Patrick C. Simonds" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Is there any way to format a cell to display time to the millisecond?
>
>
 
Reply With Quote
 
Peo Sjoblom
Guest
Posts: n/a
 
      29th Oct 2008
TIME can only use integers, it
works like you would have INT inside it

--


Regards,


Peo Sjoblom

"Bernard Liengme" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Peo,
> What am I doing wrong?
> Cell has =TIME(3,4,5.125) and is formatted as hh:mm:ss.000 but displays
> 3:04:05.000
> Thanks
> --
> Bernard V Liengme
> Microsoft Excel MVP
> http://people.stfx.ca/bliengme
> remove caps from email
>
> "Peo Sjoblom" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> hh:mm:ss.000
>>
>>
>>
>>
>> --
>>
>>
>> Regards,
>>
>>
>> Peo Sjoblom
>>
>> "Patrick C. Simonds" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>>> Is there any way to format a cell to display time to the millisecond?
>>
>>
>
>
 
Reply With Quote
 
Peo Sjoblom
Guest
Posts: n/a
 
      29th Oct 2008
One way when using TIME to add 125 milliseconds <g>

=TIME(3,4,5)+(125/24/60/60/1000)

--


Regards,


Peo Sjoblom

"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> TIME can only use integers, it
> works like you would have INT inside it
>
> --
>
>
> Regards,
>
>
> Peo Sjoblom
>
> "Bernard Liengme" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Peo,
>> What am I doing wrong?
>> Cell has =TIME(3,4,5.125) and is formatted as hh:mm:ss.000 but displays
>> 3:04:05.000
>> Thanks
>> --
>> Bernard V Liengme
>> Microsoft Excel MVP
>> http://people.stfx.ca/bliengme
>> remove caps from email
>>
>> "Peo Sjoblom" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> hh:mm:ss.000
>>>
>>>
>>>
>>>
>>> --
>>>
>>>
>>> Regards,
>>>
>>>
>>> Peo Sjoblom
>>>
>>> "Patrick C. Simonds" <(E-Mail Removed)> wrote in message
>>> news:%(E-Mail Removed)...
>>>> Is there any way to format a cell to display time to the millisecond?
>>>
>>>
>>
>>
>
>
 
Reply With Quote
 
Bernard Liengme
Guest
Posts: n/a
 
      29th Oct 2008
Many thanks
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> One way when using TIME to add 125 milliseconds <g>
>
> =TIME(3,4,5)+(125/24/60/60/1000)
>
> --
>
>
> Regards,
>
>
> Peo Sjoblom
>
> "Peo Sjoblom" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> TIME can only use integers, it
>> works like you would have INT inside it
>>
>> --
>>
>>
>> Regards,
>>
>>
>> Peo Sjoblom
>>
>> "Bernard Liengme" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>>> Peo,
>>> What am I doing wrong?
>>> Cell has =TIME(3,4,5.125) and is formatted as hh:mm:ss.000 but displays
>>> 3:04:05.000
>>> Thanks
>>> --
>>> Bernard V Liengme
>>> Microsoft Excel MVP
>>> http://people.stfx.ca/bliengme
>>> remove caps from email
>>>
>>> "Peo Sjoblom" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> hh:mm:ss.000
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>>
>>>>
>>>> Regards,
>>>>
>>>>
>>>> Peo Sjoblom
>>>>
>>>> "Patrick C. Simonds" <(E-Mail Removed)> wrote in message
>>>> news:%(E-Mail Removed)...
>>>>> Is there any way to format a cell to display time to the millisecond?
>>>>
>>>>
>>>
>>>
>>
>>
>
>
 
Reply With Quote
 
 
 
Reply

« XL2007 Spreadsheet is hiding - how can I view and edit it? | Sumproduct Question »
Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Time milliseconds format Kaykayme Microsoft Excel Programming 6 29th Oct 2008 05:44 PM
Can time be measured to milliseconds? =?Utf-8?B?UGZsdWdz?= Microsoft Excel Programming 2 22nd Jun 2006 12:40 AM
How to combine milliseconds with date/time reference and display? =?Utf-8?B?QnJ1Y2U=?= Microsoft Excel Worksheet Functions 5 27th Apr 2006 07:44 AM
display milliseconds =?Utf-8?B?dGp0amp0anQ=?= Microsoft Access 1 3rd Aug 2005 09:56 PM
Getting the time down to milliseconds =?Utf-8?B?TmV2aWUgYW5kIFBoaWw=?= Microsoft Access Form Coding 7 2nd Jan 2005 10:21 PM


Features
Forums Startup Database Reviews Articles FAQ / Guidelines About Us
 

Advertising
 

Newsgroups
Windows Vista Windows XP Microsoft Word Microsoft DotNet Windows 2000 AntiSpyware Microsoft Access Microsoft Excel Microsoft Outlook Hardware
 


All times are GMT +1. The time now is 10:21 PM.
Powered by vBulletin®. Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2010, Crawlability, Inc.
Contact Us - Archive - Privacy Statement - Top