Convert time to micro second in Ms Excel

Please help me convert to the format in micro second using,using Ms Excel.

it should be hh:mm:ss.######,not getting the thought how to crack it,Please help me here.
Have to convert the below values into Micro Seconds,copied it from database,where it shows values as correct.
FIX_OUT_TIME      FIX_IN_TIME
10:02:28      10:02:28
12:27:40      12:27:40
10:07:28      10:07:28
14:04:32      14:04:32
zonate_toasterAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
jppintoConnect With a Mentor Commented:
You can use the following formula:

=(A1)*24*60*60*1000*1000

This is supposing you have values starting on cell A1 and down.

jppinto
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Hello zonate toaster,

to display milliseconds in Excel, use the custom format

hh:mm:ss.000

Can you explain what the elements of your data sample are? Is the first number in front of the : the hour or the minute?

cheers, teylyn
0
 
jppintoCommented:
Please take a look at the attached file.

1000 micro seconds= 1 mili second
1000 mili seconds = 1 second

To convert the time value to seconds, you just need the formula:

=(A1)*24*60*60

To convert it to mili seconds, multiply the value by 1000.
To convert it to micro seconds, multiply the value by 1000 again.

jppinto
MiliSeconds.xls
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
zonate_toasterAuthor Commented:
Please convert the column B and C value in micro seconds.
Teylyn buddy it was a help,i can covert it to milli second,help me more to conver it to micro second.

Jppinto you are not getting my question.you are coverting the whole value in seconds,i told you have to conver the value like hh:mm:ss.mmmmmm(where mmmmmm is micro second value).Please help me here.
Latency-info-savvis.xls
0
 
jppintoCommented:
hh:mm:ss.000000
0
 
zonate_toasterAuthor Commented:
When i try to do this,getting the error message,snapshot is attached for the same.
Error-Message.bmp
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
zonate, I think with the term "convert" you are creating some confusion. As I understand it, you don't want to convert but to display the microseconds.

This can not be achieved in the same way as the millisecond format.
0
 
jppintoCommented:
If you want to convert the values into miliseconds, the way to do it is as I showed you...
0
 
zonate_toasterAuthor Commented:
i have to convert it to micro -second,do you guys get my point.?

Help me change the format or help me write the formula for it.
0
 
jppintoCommented:
On my previous post, instead of "miliseconds", I meant to say "microseconds"!

Convert the values into microseconds, here is (again!) the formula:

=(A1)*24*60*60*1000*1000

jppinto
0
 
barry houdiniConnect With a Mentor Commented:
Hello zonate toaster,
Why do you need to do this? Are you trying to display microseconds so that you can do further calculations or just for display purposes?
As Teylyn says, there isn't a micosecond format in Excel, in fact you can't display time in Excel with any more precision that milliseconds.....and in any case, looking at your data, if you ever had more precision you've lost it now because if you use jpintos formula to convert to microseconds then you'll see that they are all divisible by 1000, i.e. you only have millisecond precision anyway......
regars, barry
0
 
zonate_toasterAuthor Commented:
Ok.If this is the case.
0
 
zonate_toasterAuthor Commented:
TThanks All,much appreciated.
0
All Courses

From novice to tech pro — start learning today.