Dear experts,
How to subtract time in hours and minute
10:30 AM
- 10:30 PM
=
Thanks Regards
Neeraj Chauhan
+91-9756706350
neerajchauhan...@gmail.com
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official
Any Hope?
Regards
On Tue, Jul 16, 2013 at 9:20 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote:
File your reference, the noorain.ansari
2013/7/16 vikas khen vikk...@gmail.com
Hi Team,
Expecting replay on this mail as It will very helpful for me
Regards
On Thu, Jul 11, 2013 at 1:43
Please find attachment.
it might help you
On 7/17/13, Neeraj Chauhan neerajchauhan...@gmail.com wrote:
Dear experts,
How to subtract time in hours and minute
10:30 AM
- 10:30 PM
=
Thanks Regards
Neeraj Chauhan
+91-9756706350
neerajchauhan...@gmail.com
--
Hi
pfa
Anil Kumar
From: Neeraj Chauhan neerajchauhan...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wednesday, 17 July 2013 3:41 PM
Subject: $$Excel-Macros$$ Help Required
Dear experts,
How to subtract time in hours and minute
10:30 AM -
Dear All,
When I am opening an excel file it seems it is open but not visible. Seems like
entire workbook is as been hidden.
Can someone please help how can we retrieve that file.
Rgds Kaushal
Rgds, Kaushal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
post the file at group.
-- Forwarded message --
From: Kaushal Kumar kaushal.anal...@live.com
Date: Wed, Jul 17, 2013 at 5:54 PM
Subject: $$Excel-Macros$$ Un hide a workbook
To: Excel VBA Group excel-macros@googlegroups.com
Dear All,
When I am opening an excel file it seems it
Hi All,
I've found a more simpler way to get the time in hrs and minute..
And yes i've seen all ur tricks for this..i dnt know where my trick
fails...but i am getting the desired output via my trick also..
so its a question just out of curiosity that my trick is wrong or not, and
if it's
Respected Vikas,
There is no problem with the tracker.Just enable the macros of excel.For
inputting any new data do not type manually but use the button given and
type the data into the dialogue box you get after pressing the button.
**
Regards,
VijayKumar
--
Are you =EXP(E:RT) or
It's awesome.
-- Forwarded message --
From: Anonymous singhoram...@gmail.com
Date: Wed, Jul 17, 2013 at 5:57 PM
Subject: $$Excel-Macros$$ Re: Help Required
To: excel-macros@googlegroups.com
Hi All,
I've found a more simpler way to get the time in hrs and minute..
And yes i've
Hi All,
I am looking for a macro by which i Can import all the review comments in a
document (word,Excel,PDF,Visio) in to a Excel sheet.
Features I am looking for:-
1. Select a document by browsing local files.
2. Import review comments from the file selected to a Excel .
3. Clear review
Respected Neeraj,
Excel stores all dates as integers and all times as decimal fractions. With
this system, Excel can add, subtract, or compare dates and times just like
any other numbers, and all dates are manipulated by using this system.Times
are stored as decimal numbers between .0 and .9,
Respected Kaushal,
I think that the file is saved as read only and modifications and editing
are prohibited.The procedure of saving the excel file or any office file as
read only is as per the following link
http://support.microsoft.com/kb/214094.You can see the file but hen you
open the file the
Hi Vijay,
File was hidden from the standard window command. Praveen has already answered
this query.
Thanks Rgds,
Rgds, Kaushal
-Original Message-
From: P.VIJAYKUMAR vijay.4...@gmail.com
Date: Wed, 17 Jul 2013 12:56:25
To: excel-macros@googlegroups.com
Subject: Re: Fwd:
Respected Anil,
The dashboard is wonderful and fabulous.If you have designed it yourself
you are a top class excel genius and a excel expert.
Thanking you once again for the Dashboard.
Regards,
VijayKumar
On Wed, Jul 17, 2013 at 2:10 PM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
Dear
Hi Kausal,
This is not possible to hide all sheets in excel. atleast one file should
be visible. i hope the rows and colums are hidden.
just check u can see the sheet names in that file. if so then just try to
unhide the rows and columns.
To unhide the rows and columns:
in 2007 verson : Goto
Respected Kaushal,
If the file is hidden through a standard windows query you can go to the
properties tab and uncheck the hide button to unhide the sheet.Sometimes it
may be encrypted or user permissions to open or modify the file may be
restricted by the system administrator or the owner of the
Hi all,
I want total Calories of Snickers and Potato from below data ..Output is
1150, please solve..
*ColumnA ColumnB Column C Column D*
Candy Calories Fruits Vegetables Calories Snickers 350 Tomato 10
Twix 370 Potato 40 Skittles 450 Tomato 30 Snickers
try this
Sub abc()
MsgBox ActiveCell.SpecialCells(xlLastCell).CurrentRegion.Address
End Sub
On Tue, Jul 16, 2013 at 8:44 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hi,
How to know how many ranges are there in the attached workbook and how to
select last range using Area
=SUMPRODUCT(($A$2:$A$9=Snickers
)*($B$2:$B$9)+($C$2:$C$9=Potato)*($D$2:$D$9))
see if it helps
On Wed, Jul 17, 2013 at 7:33 PM, Deepak Singh dpk85si...@gmail.com wrote:
Hi all,
I want total Calories of Snickers and Potato from below data ..Output is
1150, please solve..
*ColumnA
Hi,
Thanks for your reply. I need to know which is the last range and paste it
in sheet2. Is there anyway to do this.
Please find attached updated excel there will be many ranges in sheet1
but I should know which is last range and paste same in sheet2.
Regards,
Chandra
On Wed, Jul 17, 2013
can you share the sample files
On Wed, Jul 17, 2013 at 6:11 PM, chenna reddy chennareddy...@gmail.comwrote:
Hi All,
I am looking for a macro by which i Can import all the review comments in
a document (word,Excel,PDF,Visio) in to a Excel sheet.
Features I am looking for:-
1. Select a
check this out http://www.geocities.jp/kenj_uda/en/Ray.html
On Tue, Jul 16, 2013 at 7:09 PM, Mog Godiva-Man osaze...@gmail.com wrote:
Hi experts,
Does anyone know how to write a macro to create a skyline chart very
basic. Based on date.
Thanks,
Godiva
--
Are you =EXP(E:RT) or
Hi
Kindly note that sql.request is functional in MS Excel 2007 but not in MS
Excel 2010. Could you please let me know any VBA code that would be a
substitute for sql.request.
If yes, Please let me know with the help of an example.
We use sql.request to transfer data from MS Access to MS Excel in
Sub sample()
Sheets(1).Range(a65356).End(xlUp).CurrentRegion.Copy
Sheets(2).Range(a65356).End(xlUp).Offset(1, 0)
End Sub
On Wed, Jul 17, 2013 at 8:00 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hi,
Thanks for your reply. I need to know which is the last range and paste it
try the attached file see if it helps. make changes in the macro as per
your requirement
On Mon, Jul 15, 2013 at 11:04 AM, Rajan sharma rajansharma9...@gmail.comwrote:
Dear All,
How can we plot the data below in chart. i am expecting the chart as
like in attached file. plse find the
Hi
I am not able to access the ImportAccess.zip folder that you have send
across. Please look into the issue.
Thanks regards,
*Sandeep Kumar Baranwal*
Business Analyst
Credit Risk Methodology Wholesale Basel,Genpact
Gurgaon
India
Mob:-+91-8588802543
On Wed, Jul 17, 2013 at 8:59 PM, Basole
26 matches
Mail list logo