| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I enter a cell value into the Timevalue() function?
I have to enter a time into cell (b1) and subtract that time from cell (c1).
I can do that and get an answer. I get an answer in cell (d1). I have all the cells formatted in the hh:mm mode and everything works fine. I need to be able to determine if the time in cell (c1) is greater than (meaning later than) 7pm so I can charge a different rate. I can't seem to get the timevalue(c1) to give me anything other than an #value error. I can't enter a " ' " before this value because it has to be computed. I would also like to enter a datevalue() function without having to enter the " ' ". |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Enter data and Function in same cell | Excel Discussion (Misc queries) | |||
| IF function won't post cell values | Excel Discussion (Misc queries) | |||
| WHAT FUNCTION 2 ENTER SO THE CELL TURNS RED AFTER CURRENT DATE | Excel Worksheet Functions | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Can function in one cell change value or function in another cell? | Excel Worksheet Functions | |||
Threaded Mode
