• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    How to get date from text string

    WoW!!! Thanks sir.. It is working. Thanks a lot..
  2. A

    How to get date from text string

    I have a long list of a text containing "mmm dd yyyy hh:mm:ss". e.g. May 21st 2013 21:42:04 Mar 22nd 2013 21:38:18 Dec 23rd 2013 21:37:15 Oct 1st 2013 21:35:48 Jan 1st 2013 21:32:37 Mar 3rd 2013 21:32:02 Apr 2nd 2013 21:29:51 Jun 20th 2013 21:28:19 Feb 21st 2013 21:25:30 I want to...
  3. A

    How to check double dates in a list?

    Hi all, I am working on a project and srucked on this- If I have a list of dates as mentioned bellow. And there are some dates which are entered two-three times. But we dont know which they are, How to check those dates in given list? e.g- 27-Jan-12 12-Feb-12 01-Mar-12 03-Apr-12...
  4. A

    Welcome new Excel Ninja - Faseeh

    Hi Faseeh.. Congrats dude.. Thats really great to see you with Ninja's black garb and belt. and thanks for sharing your Precious knowladge. Thanks a lot. Enjoy.. Atul Rajratna.
  5. A

    Automatically updating one spreadsheet from another

    Hi Sean & Narayan, Actually I was looking for the same resolution.. Our all agents use individual worksheets to fill up the completed work. By end of the day we open all the 10-12 files and copy all the data to the master sheet, I think, Sean & my problem is same so once I will get the idea...
  6. A

    Workday with non-adjacent multi Holiday ranges

    me too.. Thanks "TEAM", thanks a lot!
  7. A

    Workday with non-adjacent multi Holiday ranges

    Hi all, nice work done by everyone here.. Actually we were facing the same problem while working. We use diff-diff action by dates, depends on customer request and by mistake agents used to add wrong action by date due to so many request in a day. so I created a worksheet where you just need...
  8. A

    Facing problem with line graph

    Hi Annen, I'm agree with Faseeh Suppose the table is- _| A | B | C | 1| 0 | 1 | 2| 0 |45%| 3| So the data source will be like this- Values in X-Series: =Sheet1!$A$1:$B$1 (i.e- 0,1) Values in Y-Series: =Sheet1!$A$2:$B$2 (i.e- 0,45%) so the line will start from 0, you can also add...
  9. A

    Ideas for a Six Sigma project

    Faseeh, you are right.. We must have to think about agents capacity. We can try it by another way as well, thank you so much for the new ideas and new file, I will check and will work on it. THANK YOU AGAIN for your "SHIFT MANAGEMENT" worksheet. :) Atul
  10. A

    Ideas for a Six Sigma project

    Here is the sample file- https://skydrive.live.com/redir.aspx?cid=92bd629a339d0180&resid=92BD629A339D0180!116&parid=92BD629A339D0180!112&authkey=!AHmtUhtGqfHv0s8 Thanks, Atul
  11. A

    Ideas for a Six Sigma project

    Hi Faseeh, That's correct! Ans. 02- In 1st hour we had 50 faxes, in second hour it becomes 60, but between that 1 hour we have processed 40 faxes, It means PENDING WORK in that hr: 50-40= 10 Faxes NEW WORK: 60-10= 50 Faxes so pending 10 faxes means, variation is low, but if the PENDING or...
  12. A

    Ideas for a Six Sigma project

    Hi team, This might be quite different (or stupid) question I'm asking on this forum but I need some help to make more improvements in my project. I am working on a Six Sigma project, subject is 'SHIFT & OVERTIME MANAGEMENT'. off-course its completely EXCEL based. I am done with the 'shift...
  13. A

    How to neglect zero's in chart?

    Hi team, I have a chart based on a run rate table. the table shows percentage of current over. so there are some numbers as well as zero's. Suppose the game is in 9th over & run rate is 15.71 but the series goes down as 10th & next all overs have number 0 in the table. The series should be...
  14. A

    Highlight the cell range by selecting dropdown

    Hi Faseeh, Thank you so much! Its working, Rocking actually.. Regards, Atul
  15. A

    Highlight the cell range by selecting dropdown

    Faseeh, Its showing the number of faxes completed by agents in that shift. not received numbers. Result(K17) should be- 778 faxes as per your sheet(range C3:L3 - 1.30 AM to 10.30 AM). How to do that? Atul
  16. A

    Highlight the cell range by selecting dropdown

    Faseeh, Yeah, I copied drop-down list of shifts to your sheet, and the cell ranges are highlighting as per shift. Its fantastic. The formula- =AND(D$6>=TIMEVALUE(LEFT($B9,4)),D$6<=TIMEVALUE(MID($B9,FIND(":",$B9)+1,7))) is gr8! gr8!! gr8!!! Hope it will work in 2003, How did you...
  17. A

    Highlight the cell range by selecting dropdown

    Hey Faseeh, m so sorry for the delay. & Its working yaar, great.. Thanks, Thanks a lot. now agent count(2) and completed faxes count(171) is done. but what about the total count of faxes we received in the shift? i.e 778 (sum of faxes in C3:S3 range) and how to make conditional formatting...
  18. A

    Highlight the cell range by selecting dropdown

    Yes, but counting non-blank cells will also calculate the other shifts number as well. b'coz we have so many shifts in between. I'm not getting the proper formula actually. but the results should be like this- We have 3 agents in selected 1 am to 10 am shift. (Agents count) The total work...
  19. A

    Highlight the cell range by selecting dropdown

    Faseeh, I am done with productivity, it is already there. once I'll get agent count and faxes count in the shift, I'll get the productivity. I counted the numbers in agents count column manually. I want to count the total agents available in that shift, and total faxes received in that...
  20. A

    Highlight the cell range by selecting dropdown

    Hi DonMinter, How can I use conditional formatting after changing the time-frame from 5AM to 5.00 AM? or should i change the drop-down list? instead of using shift start timing 5AM, should I use 5.30 AM as work start time? Thanks! -Atul
  21. A

    AMOUNT ENTRY

    Hi Sa.1985, Why do you want to enter all the numbers in formula? you can do this- enter the numbers in SHEET1 as B1 100 B2 200 B3 300 B4 400 B5 500 A1 =sum(B1:B5) > so you will get the SUM > 1500 so in future, if you want to change the numbers you can change it. no need to...
  22. A

    Highlight the cell range by selecting dropdown

    Hi SirJB7 & Narayan, m extremely sorry! I dont know, why but m also getting the same error. so I have uploaded a new folder with both files, Please try with this. https://skydrive.live.com/redir.aspx?cid=92bd629a339d0180&resid=92BD629A339D0180!112&parid=root Thanks. -Atul
  23. A

    Highlight the cell range by selecting dropdown

    Hi all excel gurus, I have created an Shift Time Manager worksheet where we will come to know about the exact work flow and the work completion flow. I have uploaded two files, please read the notes and help me. 1st) I need your help in this-...
  24. A

    Flexible flow chart

    Hi Annen, I have uploaded new file with some changes & suggestions. I have 1 suggestion to you, instead of showing all the data only in one chart you should use two charts. 1st chart will display the details of agents work for all the 5 days (which we are currently selecting by drop-down)...
  25. A

    Flexible flow chart

    Annen, you mean, you want to compare the data of Mortgage Australia with Mortgage USA. Right?
Back
Top