# Convert time to micro second in Ms Excel

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
###### Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x

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

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

Commented:
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

Author 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

Commented:
hh:mm:ss.000000
0

Author Commented:
When i try to do this,getting the error message,snapshot is attached for the same.
Error-Message.bmp
0

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

Commented:
If you want to convert the values into miliseconds, the way to do it is as I showed you...
0

Author 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

Commented:
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

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

Author Commented:
Ok.If this is the case.
0

Author Commented:
TThanks All,much appreciated.
0