Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. seabubble

    Bank Holiday formula in Excel

    sorry xlbo I thought I was in the right one. Will not post here again.
  2. seabubble

    Bank Holiday formula in Excel

    I can now get the formula to look at the date range and work for one cell. BUT if I drag the formula to the next cell the holiday data cell changes by one. ie .(E14,F14,GraphData!A2:A3) changes to(E14,F14,GraphData!A3:A4) I know there is something to fix the range but cant remember...
  3. seabubble

    Bank Holiday formula in Excel

    Hey its working! Thanks. I will now try and get the formula to look at a range so I can add the dates I need.
  4. seabubble

    Bank Holiday formula in Excel

    I have tried to do the following =IF(F14>0,10/24*(NETWORKDAYS(E14,F14)-2)+TIME(18,0,0)-(E14-INT(E14))+(F14-INT(F14)-(3/1/2005))-TIME(8,0,0),"Unresolved") What happens is that it takes the 8 hours off even when the holiday date is not withing the start and end times!
  5. seabubble

    Bank Holiday formula in Excel

    Thanks for replying MrMovie. I was wondering if the dates are held in part of the sheet or a text document. If they are how would I use them?
  6. seabubble

    Bank Holiday formula in Excel

    Hi All, I have the following formula in a spread sheet. It works out the total SLA hours in the week from start date to end date. =IF(F14>0,10/24*(NETWORKDAYS(E14,F14)-2)+TIME(18,0,0)-(E14-INT(E14))+(F14-INT(F14))-TIME(8,0,0),"Unresolved") This works well if the times are weekdays between 8...
  7. seabubble

    week on week chart

    Hey I done it ! but differently if {@Arrival date} in {@go back a week} to today then yellow else if {@Arrival date} in Over90Days then blue else white {go back a week} today - 7
  8. seabubble

    week on week chart

    Hi Madawc, Can't get my head around this one. I have looked in the manuals but it does not show this field. I do dayofweek (date -7) but get not enough arguments. I thought it would do the dayofweek is today - 7 therefore if I run it on thursday it should be last thursday is the start of...
  9. seabubble

    week on week chart

    Thanks Madawc, Will try this tomorrow.
  10. seabubble

    week on week chart

    I have sorted the dates into weeks but they are not thursday to wednesday. Do I have to make a formula that subtracts 3 from sundat to get thursday?
  11. seabubble

    how to sort a formula field with having running total of a formula fie

    Hi all, This is exactly what I am working on at the moment. I have my report with Business Objects, they have been helping. What I have done so far is build the main report holding the data. Then make a sub report that uses shared fields on both the main and sub report. This "copies" the...
  12. seabubble

    week on week chart

    Hi, I need to show a graph which plots a week on week total of records opened. I am reporting from thursday to wednesday. But the end of week is friday. How do i group the records raised by thursday to wednesday? I know how to do the totals and charts. I just can't get my head around how...
  13. seabubble

    SQL select and group by help

    Hi SQLBill. Been really busy, like all of us. This stuff is inside Crystal reports. It is a seperate section you can do extra sql while the report is running. Thanks for the tip about BOL. I will hunt someone down who has the CD as it's not running on this pc as it's on the server.I must...
  14. seabubble

    SQL select and group by help

    SQLBill - Backend is SQL server this sql is inside Crystal reports. DBomrrsm Cant find that part to click on I am inside crystal reports sql expression builder I have been in a four hour meeting so could not get back sooner. Will have a go but it will be tomorrow as it's late here. I...
  15. seabubble

    SQL select and group by help

    Hi again, First it said that there was a syntax error near select. That was the ( missing. Then when I fixed that it said that there was a syntax error near from, but did not say which from. I also took the red text out and put "ARSystem"."dbo"."AST_Asset" at the top (SELECT...
  16. seabubble

    SQL select and group by help

    I think that Crystal reports puts the added SQL expression into the main SQL, looks like that anyway.
  17. seabubble

    SQL select and group by help

    Sorry ! SELECT "AST_Asset"."Region", ((select distinct count("AST_Asset"."Asset_ID_") from AST_Asset where "AST_Asset"."Type" = 'ROUTER' and ("AST_Asset"."Status" = '6' or "AST_Asset"."Status" = '0') ) ) FROM "ARSystem"."dbo"."AST_Asset" "AST_Asset" WHERE NOT...
  18. seabubble

    SQL select and group by help

    Thanks for getting back DBomrrsm. I have put the following in (select distinct count("AST_Asset"."Asset_ID_") , "AST_Asset"."Region" from AST_Asset where "AST_Asset"."Type" = 'ROUTER' and ("AST_Asset"."Status" = '6' or "AST_Asset"."Status" = '0') group by "AST_Asset"."Region") and get "Only...
  19. seabubble

    SQL select and group by help

    Hi, This is the first time I have used the SQL forum. At the moment my SQL looks like this (select distinct count("AST_Asset"."Asset_ID_") from AST_Asset where "AST_Asset"."Type" = 'ROUTER' and ("AST_Asset"."Status" = '6' or "AST_Asset"."Status" = '0') ) this gives me a figure of 1034. I...
  20. seabubble

    Grouping with SQL expression field

    Hi ro, and synapsevampire, thanks for replying. :0) I'm in England, depending on where you are replies may take time! I have put the following in with and with out quotes. (select distinct count("AST_Asset"."Asset_ID_") from AST_Asset where "AST_Asset"."Type" = 'ROUTER' and...

Part and Inventory Search

Back
Top