Recent content by Monkeyboy126

Got it working fab, thanks to all! Cheers

xlhelp - This is exactly what I need and works very well. Can I ask how the .42 and .65 relate to hours in the day? many thanks

Apologies, try this link to Spreadsheet http://www.mediafire.com/?uyt6fzep75mfzkahttp://www.mediafire.com/?uyt6fzep75mfzka

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