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...
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...
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...
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.
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.
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.