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

    IBM T30 - Modem Hyper Terminal

    No Dial Tone. Using Win XP. Connecting into a PABX system for remote management. Works Fine with IBM T42. But not with T30 or T40.
  2. brunnle2

    IBM T30 - Modem Hyper Terminal

    Having a problem using the On-board modem (Agere Systems AC97) in a Hyper Terminal Session. Any ideas?
  3. brunnle2

    HP 1320TN

    I have a networked 1320TN. Installed on Win2000. Users are on XP sp2. I need to configure the print options so that when a user wishes to print stationary it picks from tray 3. All other by default to tray 2. I have played with the Printer setting default options, and have saved different...
  4. brunnle2

    Excel - dd/mm/yy hh:mm:ss formula

    I have two Date & Time columns (dd/mm/yyyy hh:mm:ss). One is an open time, and another is the closed time. What I need to calculate in hours, is what is the elapsed time between the two. Closed Time - Open Time works if time elapsed is <24 hours. anything >24 hours and the elapsed time goes back...
  5. brunnle2

    Excel Function

    They have actual times. This is the Date and time that a call was made in the system. It is required to report on Service Levels. Can I add a string reference to the "=" so that it looks at only the first chars, i.e. dd/mm/yyyy. Or is there an easy way I can split my exported cells that have...
  6. brunnle2

    Excel Function

    I did try that, but the value is 0. I guess this is because of the cell formatting. FF!D:D is dd/mm/yyyy hh:mm:ss and A5 is dd-mmm-yy. So they will not "=" to one another. I'm sure there is a way round it. Hopefully you might know? Tvm, Leighton.
  7. brunnle2

    Excel Function

    Great that worked! - Thanks Geoff... One more problem though I need to add a ">=" into the function, so that It counts only one date. I Tried: =COUNTIF(FF!D:D,"<=" & $A5 ">=" & $A4) But this gives an error.
  8. brunnle2

    Excel Function

    Still trying.... HELP ME!! At the moment I have =COUNTIF(FF!D:D,"<=$A5") in my cell where I wish to count all cells where the date is less than what is in cell A5. I get 0, but am expecting 29. The range FF!D:D contains the format dd/mm/yyyy hh:mm:ss. In A5 is dd-mmm-yy. I do hope I am making...
  9. brunnle2

    Excel Function

    The cells also contain the time. When data has been exported from our Database they are in the format dd/mm/yyyy hh:mm:ss
  10. brunnle2

    Excel Function

    I would like to automate some reporting I do with Excel. In one cell I need to count the number of rows in another worksheet that match that date where I am recording the data. Make Sense? For example. When I report on calls logged on 28/06/05 I need to count rows in the other worksheet where...
  11. brunnle2

    Excel 2002

    Can you increase the number of columns capabilities in Excel. Currently I can go from A to IV (256 Colummns), but had a client who has asked for more. I have commented that if the spreadsheet is that big then perhaps it should be a database. They have taken my syuggestion on board. But I wanted...
  12. brunnle2

    Server / Client email sharing

    Thanks for your reply jmgalvin. Unfortunately because of our Infrastructure Security, etc. The macs cannot join the PC network. If that is the 'network' you are referring to? You are right, I do mean sharing, OSX Server is NOT the OS, and Yes, the Internet connection is shared. I do hope there...
  13. brunnle2

    Server / Client email sharing

    I am a self confessed MAC novice, with no previous MAC supoprt experience, before I started where I work now. I now "try to" support 2 MACs. One G4, one iMAC. They are on there own network, the G4 is the server. It has OSX 10.2 Installed. Each MAC is used by a different person here, and they...
  14. brunnle2

    Applying individual protection to multiple sheets for different users

    I have a worksheet that contains a number of sheets. I would like to send this to a number of users. But each user must only be able to access there part of this worksheet. So can I protect each worksheet so that its contents are hidden to all users until a correct password is entered. Or even...

Part and Inventory Search

Back
Top