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

2014-08-29 Thread Paul Schreiner
- From: son nguyen sonnguye...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, August 13, 2014 4:27 AM Subject: $$Excel-Macros$$ Calculating working hours between 2 days with break time Dear Expert. I faced on problem while calculating

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 sonnguye...@gmail.com 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

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 v...@vabs.in: Hi Check cell in green with formula to calculate net working hours,

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 sonnguye...@gmail.com wrote: Dear Expert. I faced on problem while calculating working hours

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 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

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

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 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 : Begin time. B1 : Finish time