Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Flying hours allowing for GMT or BST
Hi
My worksheet (part of a workbook) records the amount of time spent flying, relevant columns are shown below, items in () are how the cells are currently formatted B date (ddd dd-mmm-yyyy) F take off time (hh:mm) H landing time (hh:mm) J BST or GMT difference +/- as a positive, minus not allowed (hh:mm) K Flying hours after adjusting for J (dd:hh:mm) must be able to total this column Often the landing time goes into the next day, for which currently no date is shown I have tried all sorts of formulas, and are unable tofind a universal formula to fit all options, and are now totally confused Help would be greatly appreciated Thanks Joco |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating numbers of hours worked in pay divisions | Excel Discussion (Misc queries) | |||
Calculating working hours | Excel Worksheet Functions | |||
calculating hours | Excel Worksheet Functions | |||
need help w/formula for calculating overtime hours | Excel Worksheet Functions | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions |