| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#Value Error
Since you folks were so helpful last time I have another question for you.
Say I have two cells A1 and B1 that has the cell formatted as (hh.mm.ss). Now when I try to subtract those two number I get a #Value error. Why is that? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#Value Error
you still have to key the data in as
hh:mm:ss to get excel to recognize it as a time. if you are typing the periods ".", excel will treat it as text regardless of the number format. "caldog" wrote: Since you folks were so helpful last time I have another question for you. Say I have two cells A1 and B1 that has the cell formatted as (hh.mm.ss). Now when I try to subtract those two number I get a #Value error. Why is that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom error bars not working | Charts and Charting in Excel | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Problem Opening an Excel File MSO9.DLL Error | Links and Linking in Excel | |||
| error "module not found" | Excel Discussion (Misc queries) | |||
| #REF error | Excel Worksheet Functions | |||
Linear Mode
