Thread: Formula
View Single Post
  #1   Report Post  
Metalteck
 
Posts: n/a
Default Formula

I currently have a field that subtracts the difference between an arrival and
departure time. I have also created an additional 4 fields to see a time
frame for the time difference.

I placed the formulat =IF(W4<=15,1,0) in the 15 column, but it doesn't seem
to be working correctly, just placing a 1 in the columns, regardless if it is
over or under 15. I think it has to do with formatting it in proper time
format, but don't know how to do that. Can you help?