Posted to microsoft.public.excel.misc

Arup C[_2_] Arup C[_2_] is offline

external usenet poster

Posts: 32

Time function

Hi everybody,
I have a question relating Time function. I have put time in cell A1 and
formula
"=TIME(HOUR(A1)+12,MINUTE(A1),SECOND(A1))" in cell B1 the problem is when
the hour exceeds 12 O'clock midnight it gives the error #NUM! instead of
showing the exact time suppose cell A1 has the value 4.00 PM then the formula
shows the error msg instead of showing 4.00 AM of next day

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
time function	Winkle Bill	Excel Worksheet Functions	1	August 30th 07 09:10 AM
verify use of TIME Function, Find Quantity Level compare to time-d	nastech	Excel Discussion (Misc queries)	9	July 11th 07 01:58 PM
One-time NOW() function	BigD	Excel Worksheet Functions	3	September 28th 06 06:24 PM
TIME function	Jlexky	Excel Worksheet Functions	2	December 31st 05 03:35 PM
Function to convert Time String to Time	Andibevan	Excel Worksheet Functions	6	August 19th 05 01:19 PM

All times are GMT +1. The time now is 02:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us