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.

On Sat, 7 Oct 2006 17:05:01 -0700, busterpace
wrote:

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.

Either the value in B1 is not text, or it is not a recognizable time value.

For example:

7pm is not recognized by excel as time.

7 PM or 7 P would be recognized by Excel as time. However, in most cases they
would be converted to an actual time value, and would no longer be a text
string, so would also give a value error.

From HELP:

TIMEVALUE(time_text)

Time_text is a text string that represents a time in any one of the Microsoft
Excel time formats; for example, "6:45 PM" and "18:45" text strings within
quotation marks that represent time.


--ron

Check this out:-

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

You have to scroll down.

Epinn

"busterpace" wrote in message ...
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.