Hi All,
Attached is a spreadsheet I'm working on which is for a Service Desk resources rota. The staff work numerous shifts but I'm interested in counting (on a daily basis) number of people starting before 10.00 and number of people working from 16:00 onwards (columns L and M).
Ideally the...
Just in case anyones interested, I managed to resolve this by using the following formula (assuming the data is in column D)
=IF(LEN(TRIM(D2))=0,0,LEN(TRIM(D2))-LEN(SUBSTITUTE(D2,"/",""))+1)
Many thanks
Hi all,
I have cell content that looks something like "PD/AS/FD/JD". These are actually initials of people working on a project. I need a formula that will count the number of people (or initials) for the cell content, so in the example given it would be four.
All initials are seperated using...
Hi,
The call detail would look like this but it is group as per example below:
Call ref Date Closed User Name Summary
XL908 18/07/08 JJones Cannot print to PRN1
Detail is then grouped into the date closed field and a count is undertaken on the number of Call...
Hi All,
I've looked through the forums and haven't found anything to help, so I hope this hasn't been answered already somewhere else.
CRX accessing SQL DB (Service Desk call logging tool)
I am looking to display simple call data on a single line, such as call ref number, users name, date...
Hi all,
I have a helpdesk data base which contains the following fields:
Ref
Open Date (dd/mm/yyyy 00:00)
Closed Date (dd/mm/yyyy 00:00)
Status (open, resolved etc)
I am looking to produce a report that will display all working days in a week rolling (M-F) and tell me what the backlog was on...
Can anyone tell me how to reference the named range from a different worksheet?
I have managed to name the range on the different worksheet but cannot seem to reference it from the main...
Thanks in advance
Hi all,
I am looking to develop a timesheeting system in Excel. The idea is for individuals to complete standard timesheets in Excel based on a standard template.
These will be sent to an administrator on a weekly basis and I would like the admin person to own a master timesheet that would...
Hi All,
Hopefully this is a simple question. I have developed an outlook form (stand-alone oft file) which asks the recipient a few basic questions. The form is to be sent out to around 50 users and I want a good method of collating the data returned.
As it is the form is returned and I can...
Hi All,
Hopefully this is a simple question. I have developed an outlook form (stand-alone oft file) which asks the recipient a few basic questions. The form is to be sent out to around 50 users and I want a good method of collating the data returned.
As it is the form is returned and I can...
Hi
I've seen many formulas to utilise business days but my requirement is slightly different. I run a helpdesk which has operating hours of 8.00 - 18-00 Mon - Fri & 8.00 - 13.00 Saturday.
In calculating the amount of business days a call has been open, how do I incorporate the 5 hours on...
Actually theres 3 parts to this select formula, i need:
1. a specific company (from another table)
2. Calls in an open state (active flag = 1)
3. Calls with an active flag of 0 but must of been closed in current month
Hope this defines it better...
Tried the formula but same results, still only showing closed calls.
The idea is to show all open calls (active flag=1) and added to this calls closed 9@close date) for the current month.
Maybe there is a simpler way??
Any ideas... [sadeyes]
Hi
Can anyone tell me why the Select formula below isn't working? The database (SQL) is for a helpdesk logging problem and changes and the formula will only display closed calls (so ignores the second part of the formula)
({int_org.iorg_name} = "Company x" and {@Close Date} in MonthToDate)...
Still not working. The formula below still shows any calls closed for any company (not just company x) and wont display any Open calls.
{int_org.iorg_name} = "Company x" AND
({@Close Date} in MonthToDate OR isNull({@Close Date}))
The formula below shows just company x but wont show calls...
Oh, found an exclusion.
This doesn't seem to work if for the chosen period (current month) the call is not closed (open state) and was opened the previous month...
How would I include these calls??
H E L P ! ! !
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.