| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
need form to calc EG :13:13 to 14:01 = td x 12 = miles-- multiple.
eg
Time place Time Place Diff 13:01 psc 14.01 midd 1:00 15:23 psc 16:24 midd 1:01 17:42 midd 19:23 psc 2:19 =total hrs-mins x by 12 = miles Need to calc the between 13:01 & 14:01 then the diff in time next entry Then give Add the two time diffs X by 12 to give me miles |
|
#2
|
|||
|
|||
|
Assuming =total hrs-mins is in E5, I think the formula you're looking for
would be ... =(HOUR(E5)*12)+(MINUTE(E5)/60*12) 1:00 + 1:01 + 2:19 = 4:20 4 x 12 = 48 20/60 x12 = 4 Therefore = 52 miles HTH, Gary Brown "waynehc" wrote in message ... eg Time place Time Place Diff 13:01 psc 14.01 midd 1:00 15:23 psc 16:24 midd 1:01 17:42 midd 19:23 psc 2:19 =total hrs-mins x by 12 = miles Need to calc the between 13:01 & 14:01 then the diff in time next entry Then give Add the two time diffs X by 12 to give me miles |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Worksheet Form / Database reporting | Excel Discussion (Misc queries) | |||
| how do I add data validation dropdown lists to a Form | Excel Worksheet Functions | |||
| Trying to delete form border, and it deletes all borders | Excel Discussion (Misc queries) | |||
| Adding info onto a "permanent" form | Excel Worksheet Functions | |||
| How do I set up a field in an Excel form to number it incremental. | Excel Worksheet Functions | |||
Linear Mode
