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

2014-08-28 Thread Paul Schreiner
o all the people you can, As long as ever you can.” - John Wesley - > > From: son nguyen >To: excel-macros@googlegroups.com >Sent: Wednesday, August 13, 2014 4:27 AM >Subject: $$Excel-Macros$$ Calculating working hours betw

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

2014-08-18 Thread Vaibhav Joshi
Hi Check this.. Cheers!! On Mon, Aug 18, 2014 at 11:22 AM, son nguyen wrote: > Dear Mr Joshi > > Thank for your help ,but it isn't to meet my requirement because I only > exclude sunday not weekend.You could give me a other solution. > > Thanks a lot. > Son > > > 2014-08-16 23:28 GMT+07:00 Va

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

2014-08-17 Thread son nguyen
Dear Mr Joshi Thank for your help ,but it isn't to meet my requirement because I only exclude sunday not weekend.You could give me a other solution. Thanks a lot. Son 2014-08-16 23:28 GMT+07:00 Vaibhav Joshi : > Hi > > Check cell in green with formula to calculate net working hours, put > holi

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

2014-08-16 Thread Vaibhav Joshi
Hi Check cell in green with formula to calculate net working hours, 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 wrote: > Dear Expert. > > I faced on problem while calculating working hours between 2 time (maybe

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

2014-08-15 Thread son nguyen
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 : > hi > > can you share a sample data in excel sheet. > > Thanks > > > On Wed, Aug 13, 2014 at 1:57 PM, son nguyen wrote: > >> Dear Expert. >> >> I faced on pro

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

2014-08-13 Thread Vaibhav Joshi
hi can you share a sample data in excel sheet. Thanks On Wed, Aug 13, 2014 at 1:57 PM, son nguyen wrote: > 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

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

2014-08-13 Thread son nguyen
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 -200