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

2014-11-22 Thread son nguyen
Dear all, I have problem when calculate total equipment downtime as there are overlap periods. For example : start time Finish time 8:00 8:20 9:00 12:00 10:00 11:30 ... start time,finish time are flexible. all of you might gi

$$Excel-Macros$$ Re: Want to get your question answered quickly?

2014-11-22 Thread Steve st-pierre
How could get this micro to work in excel. The macro should write the time in one row (Row A - field 1) when something is written in the second row (Row B - field 2). When I add this to any excel (Excel on mac 14.4.6) file I don't even get any errors. Could someone help me to tell me why it doe

Re: $$Excel-Macros$$ Re: VBA

2014-11-22 Thread Prafull Jadhav
Dear Paul Sir, Can you please explain what is "Debug.Assert True" Regards, Prafull Jadhav 9920553518 On 22 November 2014 at 09:55, Mandeep Baluja wrote: > Hello Paul, > > First I would like to thank you from bottom of my *heart* for making such > an *efficient code* to handle such a bad forma

$$Excel-Macros$$ Re: Macro for send mail

2014-11-22 Thread Laxmanan M
Thanks Mandeep, I have couple of questions here. With regards to the e-mail it sends, who will receive the email when I run the macro? Will this open up an email and I populate the email address? Laxman On Friday, November 21, 2014 3:48:00 PM UTC+5:30, Mandeep Baluja wrote: > > Sub Mail_Outl