I am a flight attendant and I would like to create a excel file with my flight hours. But I don't want to log the exact hours but the average f.e. if a flight to New York is 5 1/2 hours, I just want to write NY and then Excel changes that to 5 1/2 hours. Is this possible in Excel?
And then I want excel to calculate the hours flown in the last 30 days and the last 3 months.
I hope I am clear in my explanation.
Can anyone help me with this?