B_Flatblues
Board Regular
- Joined
- Dec 16, 2002
- Messages
- 54
Sorry i don't no the HTML CODE to write out equations but need help with a time rate distance formula. Cells b2 (25Min)* c2 (4.2 mil. per hr)* Hr 60min = 1.75 Mi. O K i give up cell G2 should equal 1.75 miles.
how is this written in excel?
also can i formate cells so that a user does not have to enter 00:25:00 to enter min in other words can they enter .25 and get 00:25:00. i suppose i could use a drop down list. bottom line, can i improve on this sheet?
hpoe this all makes since. please see the following
Thx
Rob W
how is this written in excel?
also can i formate cells so that a user does not have to enter 00:25:00 to enter min in other words can they enter .25 and get 00:25:00. i suppose i could use a drop down list. bottom line, can i improve on this sheet?
hpoe this all makes since. please see the following
| EXCESISE2.xls | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | |||
| 1 | DAY | DATE | WALKING | SPEED | RUNNING | SPEED | MILES WALKING | MILES RUNNING | TOTAL TIME | COMPLETED | ||
| 2 | Monday | 1/15/03 | 0:25:00 | 4.2 | 0:35:00 | 6.8 | 1:00:00 | Yes | ||||
| 3 | Tuesday | 1/16/03 | 0:00:00 | |||||||||
| 4 | Wednesday | 1/17/03 | 0:00:00 | |||||||||
| 5 | Thursday | 1/18/03 | 0:00:00 | |||||||||
| 6 | Friday | 1/19/03 | 0:00:00 | |||||||||
| 7 | SaturdayAM | 1/20/03 | 0:00:00 | |||||||||
| 8 | SaturdayPM | 1/20/03 | 0:00:00 | |||||||||
| 9 | TOTALS | 0:25:00 | 0:35:00 | 0.00 | 1:00:00 | |||||||
| 10 | AVERAGE | 0:25:00 | 0:35:00 | 0:00:00 | 0:00:00 | 1:00:00 | ||||||
| 11 | Time | Rate | Distance | |||||||||
| 12 | ||||||||||||
| 13 | ||||||||||||
| 14 | ||||||||||||
Sheet1 | ||||||||||||
Thx
Rob W
