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

    Excel - During Business hours formula

    Skip I don't suppose it would be possible to figure out if it was a Saturday or a Sunday? I would also like to give any entry on these days 0's Also, I probably should have mentioned that first....my bad Trent
  2. TrentSteel

    Excel - During Business hours formula

    Saved once again by Skip!! Thanks man! Trent
  3. TrentSteel

    Excel - During Business hours formula

    Skip As per your request: Row |USER | PLACE | TIME | ACTION 1. |J. Doe |Datacentre | 6/1/04 8:06 | open 2. |L. Roy |Cabinet | 6/1/04 8:06 | open 3. |J. Doe |Office | 6/1/04 8:09 | close thru 567.|R.Handy |Datacentre | 6/30/04 19:04 | close Does this...
  4. TrentSteel

    Excel - During Business hours formula

    Hello All I have a spread sheet of the entrance/exits to our security areas over monthly period laid out as below: |User | Place | Time | Action | I need a formula that examines C2-Cx (a period that will cover from the start of the month to the end - 06/01/04 to 06/30/04), determines if the...
  5. TrentSteel

    Exporting User Form Data to Excel

    All I am running Outlook 2002 client on Windows XP and do not have much experience working with Outlook forms nor coding with Outlook objects. Here is my dilema. I have ~215 forms that have been returned to a personal folder. The forms are a simple survey with 3 user-defined fields (option...
  6. TrentSteel

    Exporting Form Data to Excel

    All I am running Outlook 2002 client on Windows XP and do not have much experience working with Outlook forms nor coding with Outlook objects. Here is my dilema. I have ~215 forms that have been returned to a personal folder. The forms are a simple survey with 3 user-defined fields (option...
  7. TrentSteel

    Seconds to dd:hh:mm:ss

    LB & KingfisherINC, I figured it out after a few rounds of trial and error, but thanks all the same, it helped me clean mine up. Another addition to the knowledge base I suppose. :) Thanks again! -TS
  8. TrentSteel

    Seconds to dd:hh:mm:ss

    All I know that one of the FAQ's does have a formula like this: whileprintingrecords; numberVar dur:={TIME_TO_FINISH}(this is where error occurs) numberVar hrs; numberVar min; numberVar sec; stringVar hhmmss; hrs := Truncate(Truncate(dur/60)/60); min := Remainder(Truncate(dur/60),60); sec :=...
  9. TrentSteel

    Blank formula results

    Howard I don't think it is my code, since it is pretty simple: datediff("s",DateTime (1970,01,01,00,00,01), currentdatetime) - {SHR_HELPDESKSLAS.TTA_SLA_TIME}( this is a Unix time field) The problem is that I don't understand, or can't figure out really, why the results of the...
  10. TrentSteel

    Blank formula results

    Morning all Alright, I know this is something stupid and small, but I just can't figure it out. I have various reports I have been working on for weeks now, streamlining, aesthetics etc. This morning I have added a few new formulas yet whenever I try to display them on the report, with only a...
  11. TrentSteel

    Crystal Reports Distributor

    Good Day all I have been playing around with Crystal Reports Distributor (www.christiansteven.com) over the last few days, on a separate machine I have set up specifically for reports. I have no real problems with it, beyond a few glitches, and was surprisingly easy to setup and run. I was...
  12. TrentSteel

    DateTime to Unix Time dynamically

    Still working on this...update: Thx Madawc for the help,but now I have run into an related problem that I think somone may be able to help me with. Can anyone see a reason why this selection formula would be timing out? //if monday, go back 3 days for info, else 1 day and greater if DatePart...
  13. TrentSteel

    DateTime to Unix Time dynamically

    Hello All I have had no problems converting a Unix time stamp to DateTime for grouping and display in reports.(thanks to this forum, really, rather than my own reporting prowess) Now, I have begun playing with an automated report generator and exporter. Unfortunatley, I have no idea how to...
  14. TrentSteel

    String Manipulation

    Skip/Bowser This forum never fails to help out! Thanks again for two quick and easy solultions! TS
  15. TrentSteel

    String Manipulation

    Hello All I don't think this is too hard, but my formula/VBA knowledge has proven insufficient so far. I have a approx. 1800 records in a Excel Spreadsheet like this: User Name(col'm 1) John-Smith.Unit.Domain.Country I need to break apart the User Name...
  16. TrentSteel

    Changing Data sources: verify or leave formulas

    Hello all I have a fair number (25+) of reports that have been created using Crystal 8.5 and have been running perfectly against a production server. We have recently added a reporting server, but I am having to use a different ODBC connection to get the data. I was using a Remedy ODBC b/c...
  17. TrentSteel

    Sum col's in multiple worksheets, list totals

    Skip Still working with the same sheets, books, records etc...the fourth column is a date modified column. How would I be able to pull individual records based on date last modified, and display them. A little more deatil on the format of my worksheets.... Colm A - File name; eg...
  18. TrentSteel

    Sum col's in multiple worksheets, list totals

    Skip Thanks a million, worked perfect!!! TrentSteel
  19. TrentSteel

    Sum col's in multiple worksheets, list totals

    Hello all I have what I think would be a fairly simple problem, but time is of the essence. I have 6 workbooks with anywhere between 15-50 worksheets per book. Column B across all worksheets and workbooks displays file size in bites. I need to sum all Col B’s in the various sheets, within...

Part and Inventory Search

Back
Top