Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc