Attached is a spreadsheet I call Premium pay used to help Flight Attendants calculate at exactly what time they will receive Premium pay of time and a half.
There are 4 spreadsheets, one for each time zone. The user must move sideways to find the appropriate spreadsheet of the time zone they are in and insert their check in time in that time zone. The spreadsheet then calculates their duty day and displays that time in each time zone below based on what time zone they might be ending their duty day in.
Can any of you pros out there think of a way to consolidate this function into one
spreadsheet? I'm open to suggestions. Perhaps a starting time zone check box might work? Does Excel offer that?
Please have a look and tell me what you think. If you have an idea please build a quick and easy spreadsheet complete with formulas and functions to explain it. I'm new to Excel and still learning otherwise I wouldn't be here asking.
Thanks for all your help.
Greg
Bookmarks