View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Ben
 
Posts: n/a
Default New to excel,please help

Hi,

I really need help with building a formula to do the following:

A B C
Expected actual answer
08:00 08:00 Early
On-time
late
If the times match in A & B then c would equal ON-TIME if B is before A,
then c would equal EARLY,if B is later than A,then C would Equal LATE

Thanks