Posted to microsoft.public.excel.worksheet.functions

Ron Rosenfeld Ron Rosenfeld is offline

external usenet poster

Posts: 5,651

Help with Time Function

On Thu, 14 Feb 2008 22:22:32 -0500, "Rick Rothstein \(MVP - VB\)"
wrote:

Wouldn't this work (it's longer, but seems more straightforward to me)?

B2: =TIME(HOUR(A2),MINUTE(A2)+(SECOND(A2)=30),0)

It looks like it should work, also.
--ron

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
Function time	May	Excel Worksheet Functions	1	September 17th 07 04:31 PM
Time function	vito	Excel Worksheet Functions	2	August 10th 07 04:38 PM
verify use of TIME Function, Find Quantity Level compare to time-d	nastech	Excel Discussion (Misc queries)	9	July 11th 07 01:58 PM
Time VBA or NOW function	Jenny B.	Excel Discussion (Misc queries)	2	June 22nd 07 03:22 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 12:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us