HI,
Do you want this :
Format : HH:MM:SS
=TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW())+20)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aruna jayaram
Sent: Mar/Fri/2012 12:27
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Kindly
Suppose you Enter actual date on D2 Cell
enter this formula where you want this result
=IF(VALUE(TEXT(D2,SS))30,TIME(TEXT(D2,HH),MOD(TEXT(D2,[m]),60)+1,0),TIME(TEXT(D2,HH),MOD(TEXT(D2,[m]),60),0))
On Fri, Mar 2, 2012 at 12:26 AM, Aruna jayaram aruna2...@gmail.com wrote:
Kindly help me with
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Divaker Pandey
Sent: Friday, March 02, 2012 2:05 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Kindly help me with my question on Excel
Suppose you Enter actual date on D2 Cell