zonate_toaster
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
hh:mm:ss.000000
ASKER
When i try to do this,getting the error message,snapshot is attached for the same.
Error-Message.bmp
Error-Message.bmp
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.
This can not be achieved in the same way as the millisecond format.
If you want to convert the values into miliseconds, the way to do it is as I showed you...
ASKER
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.
Help me change the format or help me write the formula for it.
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
Convert the values into microseconds, here is (again!) the formula:
=(A1)*24*60*60*1000*1000
jppinto
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok.If this is the case.
ASKER
TThanks All,much appreciated.
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