| Home |
| Search |
| Today's Posts |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
.0 is creating #VALUE! Error
Hi kidcasey13
I'm not understanding - why is 15 minutes not a quarter hour? I fail to see how it could be any more accurate than that. Using your formula above, 27.25 (whether text or value) returns 1620.25 for me, which I read as 1620 minutes and 15 seconds. Perhaps you should post the contents of your source cell (27.25?) and what you expect to see in your calculated cell. Regards Steve |
| 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 | |||
| XL - Oracle connection Error | Excel Discussion (Misc queries) | |||
| Problem Opening an Excel File MSO9.DLL Error | Links and Linking in Excel | |||
| error "module not found" | Excel Discussion (Misc queries) | |||
Threaded Mode
