time problem

[species8514]

Hi guys

I have a time in a cell.. 00:04:20 and in the adjacent cell it basically says if the time in the cell is between 00:04:16 and 00:04:31, then return the number 7.

However what i am getting is #VALUE!

I have tried using floor.precise /1/24/60/60 to ensure it rounds down, but with no luck, and besides the time falls well within the range.

This forumlae is in about 100 cells, and most of them work fine. Its just a few exceptions dotted about where it doesnt.

Any ideas?

 

[Momentman]

Something like this

Excel 2010
	A	B
1	00:04:20	7
Sheet9

Cell Formulas
Range	Formula
B1	=IF(AND(A1<=TIME(0,4,31),A1>=TIME(0,4,16)),7,"")