help me with my question on Excel
Kindly help me with my question on Excel i.e., I have time in the format
01:02:40 ( hh:mm:ss) but I want the time to be shown as 01:03 i.e., seconds
to be rounded off to minutes.
And if you have any files on visual basic 2008 with examples that I can use
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
Kindly help me with my question on Excel i.e., I have time in the format
01:02:40 ( hh:mm:ss) but I want the time to be shown as 01:03 i.e., seconds
to be rounded off to minutes.
And if you have any files on visual basic 2008 with examples that I can use
to learn with screenshots and codes.