This problem is frustrating me a lot! I am calculating speed which is speed=distance/ time. The time is in milliseconds. I have tried using second function in excel which returns an integer value. I require the time returned to be in real number so that the speed calculated is more accurate. How do I go about it?
Kindly have a look in this file to understand my problem.
Problem.xls
I am new to this forum, thank You for your patience!
Last edited by Sid_b23692; 12-10-2015 at 03:08 PM. Reason: SOLVED
Can you post a small sample of your data as an Excel sheet. The answer may depend on the format of your actual data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
The paperclip icon
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Format your cell as general.
Multiply your number by 1000 to give you seconds.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Answer supplied
If you can see the attachment image, The speed=distance/ Second(D6) where the second function is working as SECOND(5.118) as 5. BY this I am loosing accuracy. Could you help me please?
A jpg is not a spereadsheet!! Please attach your sheet. We cannot see what is happening in column E!!!
What is the distance? why not treat 5.118 as a number (rather than time format)?
That"s exactly my question sir, how to treat 5.118 as a number? 5.118 was obtained by subtracting two time values and is in format ss.000 . Distance here is in metres and time in seconds so I wish to get the speed in m/s.
Last edited by Sid_b23692; 12-10-2015 at 02:47 PM.
Is there any reason why you are unable to post a sample sheet, as requested. Now even your jpg has vanished!!!
Sir, In the post you can see a link with problem.xls file. I have uploaded as asked. Kindly see that
If you want your speed in ft/seconds (I assume the 6 in E8 is feet, then
= 6/ (D8*24*60*60) format cell to general (Result is 1.172333 ft/second
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There is a link now, but there was not one at the time I posted....
ThankYou Sir, your solution has worked. Can you kindly explain why the denominator is to be multiplied with 24*60*60?
Excel uses 1 day as the unit of time. That's why you can subtract two dates to get a number of days.
So to convert what you have formatted as seconds, we multiply * 24 hours/day * 60 Min/hr * 60 Sec/min
Hope that helps.
Still not completely clear, never mind. Thanks a ton!!
I didn't explain it very well.
When you are entering data as time (hh:mm:ss.mmm or any other time format), excel sees this as a fraction of a day. If you formatted 12:00 PM as general, you'd get 0.5 because it's half a day. No matter what it looks like in the cell, it's still 0.5. So in Column D when you subtract two times and format it to ss.000, it's still a fraction of a day. If you divide feet /D8 you will get feet per day not feet per second. To convert days to seconds, you need to multiply as described.
ThankYou, Learnt something new today. Cheers!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks