Hi,
I have a spreadsheet which calculates the time of each delayed plane leaving an airport. I have been able to calculate the delay. I now wish for the spreadsheet to separate the data dependant on length of delay. For example I have tried using an if statement along the lines of =if(A1<15,1,0) to return 1 if the flight was delayed by less than 15 minutes, but this returns 1 for all flights delayed, irrespective of their departure delay.
Thanks,
Luke
Bookmarks