Search results for query: *

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...

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 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...

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...

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)...

Hi I have 2 IT Helpdesk tables (SQL), 1 storing Problem records and the other storing Change requests. Both contain similar fields such as open datetime, analyst ID, user name, summary, close datetime etc. My requirment is to produce a report based on analyst activities for the day (so how...

Hi I have a table with many fields but I am only interested in 2 (Date opened & date closed). ! ! ! ! x-----!--o ! ! ! ...

Hi I have a report that contains Helpdesk records and each has an open date and a closed date. I have a requirement to display only call that have been opened during the current month. I currently use an initial parameter field to select a date range but want this to be automatic. Any...

Hi Whenever I connect a USB device, the PC will either reboot or reboot and screw up. If it screws up the only way to recover is to boot to safe mode, delete ALL usb drivers and start again. Running Windows XP SR1 The system will start to recognise the device before rebooting. Tried...

Sometime ago I upgraded my motherboard and all was working fine. I connected my digital camera to the PC and the OP first recognised a new USB device and within seconds rebooted itself, then on re-start it freezes just before the blue progress bar appears on the start-up flash screen. I could...

I need to calculate business days between two date fields. I operate an IT Helpdesk and our 'open' hours are 8.00 - 18.00 Mon to Fri and 8.00 - 13.00 Saturday. I need to calculate business hours between two dates utilising only the hours above. I have seen Ken's business hours formula...

Hi all I want to be able to count the number of days between two dates but not including weekend days. Any ideas? Many thanks

Hi I have a Help Desk call logging database. The categories to which are are assigned are done in the following manor: Toplevel.midlevel.lowlevel (software.OS.W2K) Using drill down I want the report to show top level first, drill down to toplevel.midlevel and lastly (yes you've guessed it)...

I have a database which is used for IT helpdesk call logging. There are many tables but I am only interested in three, problem, change and contact details (used for analyst info). I need to write a report that looks at active (open) calls in each problem and change table, counts them and...

Hi CR8.5 Background: Helpdesk call logging software. Complex SQL database. Report displays a call ref number and all activities for that call (DateTime logged, DateTime of a logged comment, DateTime of escalation etc). All activities are produced from the same table (different fields)...

I have a report that displays daily data. The first column is obviously date and when grouped by "For each week), Crystal will group by a week commencing date and show the next 7 days. I need the opposite and for Crystal to display a grouped date but for the week preceeding. So a date of...