Hi All, Waiting for your reply. Please do the needful.
Regards Lokesh.M On Thu, Jul 5, 2012 at 7:24 PM, Lokesh Loki <lokeshsmg2...@gmail.com> wrote: > Hi Rajan, > > 1. Just i want macro for working days instead of formula based on user > id's. > 2. All ready you have given me a formula for macro timings but the user > "Bharathi" has worked only *one day* in a *week* and her total > timings > included macro is 4:06:16 but its showing 20:04:16 this is not correct. > 3. So i need a macro instead of formula which includes the *user working > days* + *macro timings* (i.e*.4:00:00 *hrs) in a single cell. > > Brother just need a macro which includes user working days + macro timings > based on *From date* and *To dates*. Then will get exact answer. > And the below i have given some buttons and mentioned the cell ranges for > the purpose of backup data. Here also i need a macro. > > See the attached document. > > Let me know if you have any clarification. > > Regards > Lokesh.M > > > On Thu, Jul 5, 2012 at 6:23 PM, Rajan_Verma <rajanverma1...@gmail.com>wrote: > >> HI LOKESH**** >> >> I think query is still not clear**** >> >> ** ** >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki >> *Sent:* 05 July 2012 5:14 >> *To:* excel-macros@googlegroups.com >> >> *Subject:* Fwd: $$Excel-Macros$$ Working days per employee (macro)**** >> >> ** ** >> >> Hi All, >> >> Please do the needful and provide me the solution for the below query. >> >> Regards >> Lokesh**** >> >> ---------- Forwarded message ---------- >> From: *Lokesh Loki* <lokeshsmg2...@gmail.com> >> Date: Wed, Jul 4, 2012 at 7:57 AM >> Subject: Fwd: $$Excel-Macros$$ Working days per employee (macro) >> To: excel-macros@googlegroups.com >> >> >> Hi All, >> >> Till now i did not get any reply from the experts. Please do the needful. >> >> Regards >> Lokesh.M**** >> >> ** ** >> >> ---------- Forwarded message ---------- >> From: *Lokesh Loki* <lokeshsmg2...@gmail.com> >> Date: Tue, Jul 3, 2012 at 8:58 AM >> Subject: $$Excel-Macros$$ Working days per employee (macro) >> To: excel-macros@googlegroups.com >> >> >> Hi Rajan, >> >> Before you have resolved the number of working days per employee query >> through the formula. But when i am applying the formula it takes to >> much.Hence please provide macro instead of formula to get the reports >> within 2-3 mints. >> >> And as well as i have mentioned the backup sheet names and the data >> should be posted to the same sheets with an below mentioned range. >> >> So could you please provide the macro it would be easy to get the reports >> in time and let me know for any clarification. >> >> >> Regards >> Lokesh.M**** >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com**** >> >> ** ** >> >> ** ** >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com**** >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> > > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
