**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.*