Times in Excel
I have written a spreadsheet for work that works out the monthly invoice for one of the airlines we handle. Depending on ATA and ATD and length on grnd determines the different charges we have to invoice for i.e if <3hrs rate x if >3hrs rate y, if after 1800 + 25%. Everything works except that if it arrives before midnight say 22:10 and goes at 02:00 if I put in 02:00 it comes up with ###### (bad data) but if I put in 26:00 (i.e. 24:00 + 2) it works fine. Anybody know of a way around this, the reason being I'm not always there, and others around me can't seem to get it!