Question description:
This user has given permission to use the problem statement for this
blog.
i want to use a quick formula to define speed. but its for alot of data, so i dont want to copy paste everything if thats possible
Solved by I. C. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
10/10/2017 - 10:37
Hi, Thank you for using Got It Pro.
I’m happy to be able to help you today.
User
10/10/2017 - 10:38
hi
User
10/10/2017 - 10:38
might be a real stupid question but still want to ask it
Excelchat Expert
10/10/2017 - 10:38
no worries, Glad to help
User
10/10/2017 - 10:39
i have made an example sheet since i cant show u my real sheet. its private for the company
Excelchat Expert
10/10/2017 - 10:39
ok so how do you want to calculate one cell
Excelchat Expert
10/10/2017 - 10:39
and I'll provide the formula
User
10/10/2017 - 10:39
the times are absolute times so 1:00:00 is is AM/PM
Excelchat Expert
10/10/2017 - 10:39
is it start - finish / time of start - time of finish
User
10/10/2017 - 10:40
and i want to calculate the speeds between 5-15/15-25/25-35/35-45 and if its possible the actual time from start-finish. dont need the speed for that
User
10/10/2017 - 10:41
A is in meters so 5 meter 15 meter etc
User
10/10/2017 - 10:41
c is in absolute time
User
10/10/2017 - 10:41
but i want meter per second as speed
User
10/10/2017 - 10:42
im dutch so i dont know if im explaining it well enough
Excelchat Expert
10/10/2017 - 10:42
no worries
User
10/10/2017 - 10:43
is that the formula to calculate speed in meters/second?
Excelchat Expert
10/10/2017 - 10:44
yes
Excelchat Expert
10/10/2017 - 10:45
please check the result if you want
User
10/10/2017 - 10:45
so from 5 to 15 meters he went 14.75 meters per second?
Excelchat Expert
10/10/2017 - 10:46
yes
Excelchat Expert
10/10/2017 - 10:46
it took 20 sec
User
10/10/2017 - 10:46
yea 20 seconds for 5 meters but that is 4 meters per second right?
Excelchat Expert
10/10/2017 - 10:47
so 0.5 a meter / sec
User
10/10/2017 - 10:47
wow dont read my comment
User
10/10/2017 - 10:47
im dumb
Excelchat Expert
10/10/2017 - 10:47
Is there anything else I can help you with regarding this matter?
User
10/10/2017 - 10:48
i think i have my answer now
Excelchat Expert
10/10/2017 - 10:48
When you are done with the session please click on end session.
Have a great day ahead :)
User
10/10/2017 - 10:48
uhmm
User
10/10/2017 - 10:49
0.5 meters a second is 1 meter for 2 seconds. if it took 20 seconds that is 10 meters right?
Excelchat Expert
10/10/2017 - 10:49
yes
Excelchat Expert
10/10/2017 - 10:49
from 5 to 15
Excelchat Expert
10/10/2017 - 10:49
10 meters
User
10/10/2017 - 10:50
holy shit i need a break
User
10/10/2017 - 10:50
you are right ;)
User
10/10/2017 - 10:50
then i have my answer
Excelchat Expert
10/10/2017 - 10:50
:D
User
10/10/2017 - 10:50
you will get the 5* rating
Excelchat Expert
10/10/2017 - 10:50
Thanks
User
10/10/2017 - 10:50
np
User
10/10/2017 - 10:50
have a nice day
Excelchat Expert
10/10/2017 - 10:50
You too
User
10/10/2017 - 10:51
maybe my internet is slow but when i click ok it doesnt proceed
Excelchat Expert
10/10/2017 - 10:52
give it one more try
User
10/10/2017 - 10:52
stil not working...
User
10/10/2017 - 10:52
dont want to leave without giving you a rating
Excelchat Expert
10/10/2017 - 10:54
no worries
Excelchat Expert
10/10/2017 - 10:55
the time will run out in a minute
Excelchat Expert
10/10/2017 - 10:55
you don't have to leave a rating :)
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
