hi Ashish,
Thanks for your link however i am unable to download macro file it is
stating
Macro file not found.
Can you please forward that macro file.
Thanks,
Rekha
On Sun, Apr 1, 2012 at 6:33 PM, ashish koul wrote:
> http://www.excelvbamacros.com/2011/06/excel-to-powerpoint-6.html
>
>
> On
Hi Again,
Thanks again, it's all working, I have a lot to learn what is great, you've
shown me the magic.
thanks
Pawel
From: pawel lupinski
To: "excel-macros@googlegroups.com"
Sent: Sunday, April 1, 2012 10:45 PM
Subject: Re: $$Excel-Macros$$ Re: format a
HI ALL
in first words I'd like to thanks you all ever so much for so many replies. Its
great to see how many different (great) solution is for one query. I've learn a
lot and I'm so thankful for your help. I'll try all your helpful solution.
Again thanks a lot.
Pawel
___
Hi,
There is probably a very simple solution here, but I am stumped.
In this link below, you will see a table that has a field called "TOI"
(abbreviation for time on ice). The number is visually set up as minutes
and seconds. When I bring this into excel, I am unable to convert this into
Thanks for reply . its good for me
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: 31 March 2012 22:24
To: finos; excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: sumproduct.xlsx
Don Guillett
Microsoft MVP Excel
Sale
Hello Pawel,
Another one.
=TEXT(A1*IF(ISNUMBER(FIND(".",A1)),100,1),"00\:00")
If you want to enter 2 for 2'O clock enter as 200 or cell format as text
then enter like 2.00
___
HTH, Haseeb
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titl
http://www.excelvbamacros.com/2011/06/excel-to-powerpoint-6.html
On Sun, Apr 1, 2012 at 3:04 PM, rekha siri wrote:
> hi Experts,
>
> i am attaching a macro which copies the two charts from excel and pastes
> in ppt.
>
> but can some one help to modify this code to paste two charts in one slide
*Convert the formula contain cell into Time format*
On Sun, Apr 1, 2012 at 4:20 PM, Aamir Shahzad wrote:
> Dear Maris - your formula is giving 0.23 result if enter 532, required by
> powel was 5:32
>
> Aamir Shahzad
>
> On Sun, Apr 1, 2012 at 4:07 PM, Maries wrote:
>
>> Hi Pawal,
>>
>> My tr
Dear Maris - your formula is giving 0.23 result if enter 532, required by
powel was 5:32
Aamir Shahzad
On Sun, Apr 1, 2012 at 4:07 PM, Maries wrote:
> Hi Pawal,
>
> My try,
>
> =IF(ISERROR(FIND(".",A1,1)),TIME(LEFT(TEXT(SUBSTITUTE(A1,"
> .",""),""),2),RIGHT(TEXT(SUBSTITUTE(A1,".",""),""
Hi Pawal,
My try,
=IF(ISERROR(FIND(".",A1,1)),TIME(LEFT(TEXT(SUBSTITUTE(A1,".",""),""),2),RIGHT(TEXT(SUBSTITUTE(A1,".",""),""),2),0),TIME(TEXT(INT(A1),"00"),(A1*100)-(INT(A1)*100),0))
I have tried with INT formula for decimal entries (For
Decimal condition formula shown below)
=TIME
10 matches
Mail list logo