Posted to microsoft.public.excel.worksheet.functions

sudeep

Posts: n/a

About nesting the hour function

I have an worksheet with cell C9=8:30 and D9=17.30 . Then in another cell i
compute the number of hours above 9 that i have been working by
=HOUR((D9-C9)-TIME(9,0,0)). For the above combination i get an error #NUM!.
If i do the same in 2 steps say D10=(D9-C9)-(TIME(9,0,0)) and D11=HOUR(D10)
evrything is fine. Can you tell me why and if there is any way to avoid it?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing worksheet cells from within a function	James4U2enjoy	Setting up and Configuration of Excel	1	October 14th 05 02:16 PM
Hour() function	Steven	Excel Worksheet Functions	4	October 12th 05 10:22 AM
Automatically up date time in a cell	Mark	Excel Discussion (Misc queries)	5	May 12th 05 12:26 AM
Conversion	SVC	Excel Worksheet Functions	9	February 28th 05 02:29 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE.	Robert AS	Excel Worksheet Functions	4	December 2nd 04 10:49 AM

All times are GMT +1. The time now is 04:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us