Thanks Vabz. It was indeed very helpful and saved my time. Can i ask one more thing (i m getting a bit greedy!!!)
In the sample file attached the list of employees is small and also dates. is there a formula or way where the employee code and then dates would automatically get pulled in (because the original data has too many employees and spread across 6 months i.e.180 days. So plotting the dates manually by each employee and then using this formula will consume significant time as well. Pls suggest. Rgds, Vikas Agarwal On Tuesday, April 29, 2014 5:28:05 PM UTC+5:30, Vabz wrote: > > Hi > > You can do with formula, check yellow colored area. > > Thx > > > On Mon, Apr 28, 2014 at 10:40 PM, Vikas Agarwal > <vika...@gmail.com<javascript:> > > wrote: > >> Hi All, >> >> Need some help on excel calculations: >> >> I have a data of employee attendance (daily in/out time). The extract >> from timekeeping software does come in format for me to analyse it further, >> >> Sample file of base data and output required is attached. Request you to >> pls provide me a solution so that this can be done within seconds/minutes. >> >> >> Rgds, >> >> Vikas >> >> 9820427939 >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 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) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros...@googlegroups.com <javascript:>. >> To post to this group, send email to excel-...@googlegroups.com<javascript:> >> . >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
