Calculatimg Time

E

ezeetyger

I have a cell that has calculated the number of hour from setting off
to arrival ie 3hrs. What I want is to have a column that says if the
travel time is more than 3hrs I want the letter "Y" to appear. Any
ideas how I can do that?
 
P

Peo Sjoblom

=IF(HOUR(B2-A2)>3,"Y","N")

Where A2 holds the start time and B2 the end time

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Top