Recent content by cheryl27284

woops, I'm wrong it does work!

Hey thanks a lot, but it's not working every time. The below is coming up as 1 repeat and it should be 2. The first repeat was in June and then another in Aug. H8 does ="c3" and H8 <> G8 but its not populating a 1. The formula is this: =IF(AND(H8="C3",H8<>G8),1,0 F G H I J...

This may be a hard one. I have a sheet that has employee ID's,metrics and months. I want to count how many times an employee repeated the same thing but not month after month. For example, If employee 25 had "C3" for Jan and then again in Feb I don't want it to count. But if the employee had...

Here is an easy question for you pros. I was unable to find this anywhere. I need to convert a date that looks like this: oct 16 2005 10:35PM into this 22:35.. What is the function to convert to shortdate?

Hey thanks, I will try that;)

Thank You so much! Here are 6 records. Each reason is an indicator as to why a employee logs out. So I want to know how long employee '40019' logged out for reason '4' I would have to compare the reason 4 record to the very next one to see when he logged back in. So from looking at the records...

Oh I wish it were that easy.. The problem is that the employees can logoff and logon many times so each employee has several records a day. I need to compare the first record to the very next record in line. Becuase the two records will always go together. First record they logoff at this time...

I need to figure out the duration of time someone logged off the phone for different reasons. Each record has a logoff and a Logon. In order to determine the duration I have to look at the very next record to see what the logon was. If someone logs off for a reason (reasons are numeric 1-5)the...

I have field that has the days worked like this MTWR--- or -TWRFY-. I need to count the days worked and need to exclude the dashes. How should I do this?

I have the month showing now, I just need it to sort by month and recognize that it's a date and not a text field. Right now it sorts in ABC order. Can someone help?

I finally got it to work:) thanks!! New issue, when I order by 1(first column) It puts the months in ABC order instead of month order. What do I do now? Thanks!

I'm getting a syntax error on the TO_CHAR(row_date , '%B') AS Mnt.. Is that the letter B?

I have a field called row_date which looks like: 05/01/2005.. It's in the date format. If I use MONTH(row_date) as Mnth, it comes out as a 5. I would like to format the date as May. Does anyone know a different function I could use? Thanks!

That worked!! Why group by 1? I know I could not group by month(row_date) but I tried the group by 1 and it worked?? What does that mean to group by 1?

I have a query where I want to return records with the month instead of the date. The records are listed by day. Here is the Query: Select MONTH(row_date) as Mnth,sum(acwtime)/sum(acdcalls) as acw from dagent group by ??? I need to group by the month so I do not get every record but I keep...