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

Dear Ganesh Thank for your advise but i found out there are some mistake in your formula.Please you refer enclosed file and I hope you might give new solution. Son 2014-11-26 13:26 GMT+07:00 Ganesh N ganeshg...@gmail.com: Dear son nguyen, PFA Regards, Ganesh N On Wed, Nov 26, 2014

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

,As long as ever you can.” - John Wesley* - *From:* son nguyen sonnguye...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Monday, November 24, 2014 11:22 PM *Subject:* Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods Mr

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

,To all the people you can,As long as ever you can.” - John Wesley* - *From:* son nguyen sonnguye...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Saturday, November 22, 2014 11:55 PM *Subject:* $$Excel-Macros$$ Sum downtime for equipment

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

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

Re: $$Excel-Macros$$ Calculating working hours between 2 days with break time

, put holiday in cell J so it will exclude 8 hours from total worked hours. Cheers!! On Wed, Aug 13, 2014 at 1:57 PM, son nguyen sonnguye...@gmail.com wrote: Dear Expert. I faced on problem while calculating working hours between 2 time (maybe there is diff. day).Detail as below : A1

Re: $$Excel-Macros$$ Calculating working hours between 2 days with break time

Dear Mr Joshi. Thank for your consider.Enclosed is file to you reference. Best regards Son 2014-08-13 16:05 GMT+07:00 Vaibhav Joshi v...@vabs.in: hi can you share a sample data in excel sheet. Thanks On Wed, Aug 13, 2014 at 1:57 PM, son nguyen sonnguye...@gmail.com wrote: Dear

$$Excel-Macros$$ Calculating working hours between 2 days with break time

Dear Expert. I faced on problem while calculating working hours between 2 time (maybe there is diff. day).Detail as below : A1 : Begin time. B1 : Finish time C1: Begin time day : 8 AM D1 : Finish time day : 4:30 PM E1:Begin break time F1:Finish break time How to use any formula within excel

$$Excel-Macros$$ Excel dashboards

Dear all, I just read article of report by excel dashbordas and like them but I can't get more its information.Could anyone help me as doccument,examples Look forward to hear from all of you Best Regards Son -- Join official facebook page of this forum @

Re: $$Excel-Macros$$ Excel dashboards

Thank Mr NOORAIN very much. Regards Son 2012/11/7 NOORAIN ANSARI noorain.ans...@gmail.com You can also visit *chandoo*.*org*/wp/excel-*dashboards*/ www.*excel*charts.com/blog/how-to-create-an-*excel*-*dashboard * On Wed, Nov 7, 2012 at 9:52 AM, son nguyen sonnguye...@gmail.com wrote

Re: $$Excel-Macros$$ MACRO

Dear Mr Ansari Please send it to me . (My email : sonnguye...@gmail.com) Thanks a lot Son 2012/5/31 NOORAIN ANSARI noorain.ans...@gmail.com Dear Tarun, I have send Excel macro Ebook. Pls check On Thu, May 31, 2012 at 2:57 PM, Tarun Mondal tarunmondal1...@gmail.comwrote: Sir ,

Re: $$Excel-Macros$$ Help me with a macro

Chacko samde...@gmail.com Son, the macro is written for 2007-10. Will send a modified version, but before that, can you confirm the result is correct in 2007-10? If not, what is the issue? Sam On 28/11/2011, son nguyen sonnguye...@gmail.com wrote: Hi Mr Sam. I wonder this code used for which

Re: $$Excel-Macros$$ Help me with a macro

be used for this .. Regards Rajan On Sat, Nov 26, 2011 at 8:23 PM, son nguyen sonnguye...@gmail.comwrote: Dear all, I have problem of calculating sheet.Detail as sheet attached. I want to have a macro to sum value within qty, and downtime column then delete products are duplicated within

Re: $$Excel-Macros$$ Help me with a macro

Mathai Chacko On Sun, Nov 27, 2011 at 6:40 PM, rajan verma rajanverma1...@gmail.comwrote: Hi Please see the attached file.. Pivot table can be used for this .. Regards Rajan On Sat, Nov 26, 2011 at 8:23 PM, son nguyen sonnguye...@gmail.comwrote: Dear all, I have problem of calculating

Re: $$Excel-Macros$$ Help me with a macro

, but before that, can you confirm the result is correct in 2007-10? If not, what is the issue? Sam On 28/11/2011, son nguyen sonnguye...@gmail.com wrote: Hi Mr Sam. I wonder this code used for which office as 2003,2007,2010.Because my office is 2003 and result is not to like my desirement

$$Excel-Macros$$ Help me with a macro

Dear all, I have problem of calculating sheet.Detail as sheet attached. I want to have a macro to sum value within qty, and downtime column then delete products are duplicated within each machine. I look foward to hear your help asap Best Regards Son -- FORUM RULES (934+ members already