Hi Prasad,
Divive the value with 1440 or (24*60) and change the cell formate ( go to
custom and make the cell format h:mm ) you will the correct result.
regards,
Idrees
On 8/9/09, Prasad Gadgil wrote:
>
> *Dear All Members,
>
> *To calculate productivity, I need to convert total minutes to ho
Hi ...may be u could try thisThis file was provided by one of the excel
gurus which i have been using..hope it helps u too
formula is =text2num(cell ref)..Hope u have included the macro into excel
addins
On Sat, Aug 8, 2009 at 8:01 PM, Sabyasachi Mishra wrote:
> still not working dear
>
>
Dear All,
Can anyone provide me the formulas as per the requirement in the
attachment.
Thanks in advance & Regards,
Dhananjay Pinjan
(Mob. No. 9922255533)
--~--~-~--~~~---~--~~
--
So
*Dear All Members,
* To calculate productivity, I need to convert total minutes to hours &
remaining minutes. Is there any macro / formula will solve my problem?
To elaborate,
Total number of minutes worked : 536 Min. Now if I dived this by 60 then
result is 8.93 i.e. 8 hrs and 93 min, which is
I'm new to VBA and created this code. Its working but when I attempt
to assign a variable then it doesn't calculate. Here is a snippit of
the code. The variable is 'paycode12'. When I just have it as Cells
(j, 12).Formula = Cells(j, 7) * Cells(j, 11) this format it works
fine.
Any help is
visit :
http://excel-para-todos.blogspot.com/2009/08/convertir-numeros-letras-en-excel.html
number to words.
2009/8/8 sachin patil
> Dear Mr. Ayush,
>
> I gone thru your Numbers+in+Words(Rs) file which is uploaded in Group.
>
> But if i use this formula in my normal excel file, it's not working
Thanks very much for your efforts jonell, its given me a few new ideas
to work on, I am also trying an Auto_open and scroll function.
John
On 3 Aug, 01:54, "jonell" wrote:
> Sorry, forgot to insert the attachment.
> Rgs,
> Jonell
>
> _
>
> From: jonell [mailto:jon...@live.com.au]
> Sen
Visit :
http://excel-para-todos.blogspot.com/2009/08/convertir-numeros-letras-en-excel.html
number to words.
2009/8/8 sachin patil
> Dear Mr. Ayush,
>
> I gone thru your Numbers+in+Words(Rs) file which is uploaded in Group.
>
> But if i use this formula in my normal excel file, it's not working
I am trying to do a simple macro to look at a column or line (most of
the time a column) and evaluate the length on the data on each cell
and determine if it is 10 digits. If the value of the data in the
cell is different than 10 digits (more or less). I want that cell to
change color.
it is lik
still not working dear
Regards
Sabya
On Sat, Aug 8, 2009 at 5:28 PM, mahesh parab wrote:
> Hi Sachin
>
> Please find attach sheet this will help u, formula is =Spellnum(cell value)
>
>
>
>
>
>
>
>
> On 8/8/09, sachin patil wrote:
>>
>> Dear Mr. Ayush,
>>
>> I gone thru your Numbers+in+Words(Rs
Not Working
On 8/8/09, mahesh parab wrote:
>
> Hi Sachin
>
> Please find attach sheet this will help u, formula is =Spellnum(cell value)
>
>
>
>
>
>
>
>
> On 8/8/09, sachin patil wrote:
>>
>> Dear Mr. Ayush,
>>
>> I gone thru your Numbers+in+Words(Rs) file which is uploaded in Group.
>>
>> But i
Thanks Vivek, It is very useful for me.
I want another macro to split same data as per client, but it should be in new
Excel and save in C:\.
Regards,
Shrinivas
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on
Behalf Of vivek agrawal
S
Thanks once again Vivek and sorry ignore earier mail..
Regards,
Shrinivas
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on
Behalf Of vivek agrawal
Sent: Friday, August 07, 2009 5:39 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Ma
Hi Ashish,
Press CTRL+ENTER in the cell because this is an array formula.
Regards,
Deepak Rai
Sirjee
One additional help required on ur solved work sheet regarding the problem
by Anilji. Noticed what i feel is strange behaviour.
I use Excel2007. Your formula with {=SUM(IF(E4:E8>0,E4:E8,
Hi Harris,
You can also use =IFERROR(A1,0) where A1 = #N/A.
Regards,
Deepak Rai
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Andre Dreyer
Sent: Friday, August 07, 2009 1:48 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Mac
Dear Mr. Ayush,
I gone thru your Numbers+in+Words(Rs) file which is uploaded in Group.
But if i use this formula in my normal excel file, it's not working.
Is there any additional utility ? if so, then please send me the same which
help me a lot.
--
Thanks in Advance
Sachin
Dreams are today's a
Hi Anil,
Use this formula for calculating the positive value only in a row:
=SUMIF(B1:D1,">0",B1:D1)
Where B1 = 30 , C2= -20 & D2 = 60.
Hope this will help you.
Regards,
Deepak Rai
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of AN
17 matches
Mail list logo
