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...
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...
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.
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...
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...
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...
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
Here is the sample file-
https://skydrive.live.com/redir.aspx?cid=92bd629a339d0180&resid=92BD629A339D0180!116&parid=92BD629A339D0180!112&authkey=!AHmtUhtGqfHv0s8
Thanks,
Atul
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...
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...
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...
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
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...
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...
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...
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...
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
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...
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
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-...
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)...