timevalue function

[busterpace]

I need to determine if a time value in a cell is greater than (meaning later
than) 7pm. When I enter a time value for cell (b1) and then in cell (e1) I
ask for the timevalue(b1) I get a #value error.

 

[Epinn]

Check this out:-

http://www.cpearson.com/excel/datearith.htm

You have to scroll down.

Epinn

I need to determine if a time value in a cell is greater than (meaning later
than) 7pm. When I enter a time value for cell (b1) and then in cell (e1) I
ask for the timevalue(b1) I get a #value error.