| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help me solve this calculation
Fields D17, D18, D19 and D20 have the times of departure arranged in
chronological order (i.e. D17=12.00, D18=13.30, D19=14.45 and D20 is blank). Fields E17, E18, E19 and D20 have the times of arrival arranged in chronological order (i.e. E17=13.00, E18=14.00, E19=15.00 and E20 is blank). The idea is to use F17 to calculate the difference between the first time of departure (which is always D17) and the LAST given time of arrival (E17 through E20). I've fought with this for hours but i can't make it work. Any help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| time-clock calculation | Excel Worksheet Functions | |||
Threaded Mode
