Thread: IF function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Graham Graham is offline
external usenet poster
 
Posts: 155
Default IF function

I want to use the IF function for working out the time difference between two
cells eg
if planned time was A= 09:00 and actual time B=11:00
C needs to return a value of 4 if B=A ;3 if B=A+1Hr; 2 if B=A+2Hr; 1 if B
A+3Hr