XL stores times as fractional days, so 15:00:00 = 0.625, and 00:15:00 =
0.0104166666666667.

I'm not sure what exactly you're trying to do, but if you're trying to
see if the difference is less than 15 minutes, try:

=IF(W4<="0:15:00",1,0)

or, equivalently

=--(W4<="0:15:00")

where the "--" coerces the TRUE/FALSE value to 1/0 respectively.

You could also use an arithmetic formula (using 1440 minutes in a day):

=--(W4<=15/1440)

or a time function:

=--(W4<=TIME(0,15,0))



In article ,
Metalteck wrote:

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?