Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

2014-11-23 Thread pp kk
use data entry like 8:00AM 8:20 AM Then 8:20 AM - 8:00 AM = 0:20 Pankaj Michael On Sun, Nov 23, 2014 at 10:25 AM, son nguyen wrote: > Dear all, > > I have problem when calculate total equipment downtime as there are > overlap periods. > For example : > start time Finish time > 8:00

Re: $$Excel-Macros$$ Copy/paste loop with VBA

2014-01-29 Thread pp kk
On Tue, Jan 28, 2014 at 3:25 PM, pp kk wrote: > > Dear All, > > i was stuck in a situation in Excel. When i am downloading a file from SAP > it it exporting in .xls but in different format. PFA > -- > > Thanks > Pankaj Kumar > 9910075248 > > -- > Are you

$$Excel-Macros$$ Copy/paste loop with VBA

2014-01-28 Thread pp kk
Dear All, i was stuck in a situation in Excel. When i am downloading a file from SAP it it exporting in .xls but in different format. PFA -- Thanks Pankaj Kumar 9910075248 -- 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 Facebook

Re: $$Excel-Macros$$ Mail thru Excel

2014-01-21 Thread pp kk
what's the vba password? On Tue, Jan 21, 2014 at 1:49 PM, Mahesh wrote: > Dear, > > I need an excel sheet by which I can send the mail to around 100 ppls and > attached sheet is the one which i am using already > > Problem1. > > This sheet is not working in Window 8.1 > > Problem2 > > Not able