Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Hello from Steved
Travelling at 28 Kilometres per hour Kilometres travelled is 7.6 What is the formula to tell me how long did it take. Thankyou. |
#2
![]() |
|||
|
|||
![]()
=A25/28 if you want decimal time
=A25/28/24 if you want the answer in time format (you will need to format the cell) -- HTH RP (remove nothere from the email address if mailing direct) "Steved" wrote in message ... Hello from Steved Travelling at 28 Kilometres per hour Kilometres travelled is 7.6 What is the formula to tell me how long did it take. Thankyou. |
#3
![]() |
|||
|
|||
![]()
Thanks.
-----Original Message----- =A25/28 if you want decimal time =A25/28/24 if you want the answer in time format (you will need to format the cell) -- HTH RP (remove nothere from the email address if mailing direct) "Steved" wrote in message ... Hello from Steved Travelling at 28 Kilometres per hour Kilometres travelled is 7.6 What is the formula to tell me how long did it take. Thankyou. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
time formula question... | Excel Discussion (Misc queries) | |||
How do I enter a time formula into a worksheet that determines if. | Excel Discussion (Misc queries) | |||
time formula | Excel Discussion (Misc queries) | |||
How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
Time / Formula to look at time difference | Excel Worksheet Functions |