timevalue function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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
 
Back
Top