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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ingeborg Hawighorst (Microsoft MVP / EE MVE)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 Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

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 houdiniCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.