View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matt Matt is offline
external usenet poster
 
Posts: 516
Default formula for "on time" departure.

I am working on a work spreadsheet. I have a column that is for "Scheduled
Departure", and right next to it, a column for "Actual Departure". First I
want to calculate how late or early the actual departure was in a separate
column (red for late, Green for Early) and then I want it to calculate the
percent of on time departures for the entire day. Any help with this formula?