Search results for query: *

I didn't look at any of the workbooks, but I did create a table (a1:c5) : 0 2% 0 87,813 2.25% 0 107,814 2.25% 2.50% 127,815 2.25% 2.50% 999,999 2.25% 3% And put the sales amount in F1 and used the formula...

faq68-4725 Blue [Dragon] If I wasn't Blue, I would just be a Dragon...

Didn't like mine :) Looks good... Blue [Dragon] If I wasn't Blue, I would just be a Dragon...

Try: SUMPRODUCT((A1:A5>B1:B5)*(A1:A5>C1:C5)) and adjust for each colmun Blue [Dragon] If I wasn't Blue, I would just be a Dragon...

Add an embedded if that checks to see if the number is less then 12. If so, "", if not, <formula> Blue [Dragon] If I wasn't Blue, I would just be a Dragon...

Yes, this is a puzzle. These are application files. The application will append two of them, but the third is a read only for the application. The caveat to that is I have six different deployments of this setup and this is the only one it is happening on. The NAS is using VERITAS volume...

Overview of setup: Sunray DTU session. Using terminal console to ssh to two different servers. The file resides on a NAS mount that has the same mount parameters on both servers. I have a copy of the original file on another server that is not on a NAS mount and it is still text. Some...

sorry, binary/exe type file. If you cat it, it comes back like cat'ing an executable. Blue [Dragon] If I wasn't Blue, I would just be a Dragon...

I have text files that reside on a NAS drive that are text files. Over the past couple of months, three of the files are now data files. They are shared on three different servers and today when I noticed another file has converted, if I look at the same file on another server it is still...

To give you a breakdown of how the formula works: Main function is DATE() which gives output of an excel date by giving it the year, month, and day as criteria. D5 is the year. 11 is the month. Now, for the day: The weekday() function will return a number for the day of week a date falls on...

Nice one Tony, keep forgetting about the mod. Especially since I became management, all I do is e-mail anymore anyway :) Blue [Dragon] If I wasn't Blue, I would just be a Dragon...

Just need to add the logic: =IF(WEEKDAY(TODAY())>5,TODAY()-(weekday(today())-6),(TODAY()-WEEKDAY(TODAY())-1)) Blue [Dragon] If I wasn't Blue, I would just be a Dragon...

Look at the weekday function and you should with logic utilize it for what you need Blue [Dragon] If I wasn't Blue, I would just be a Dragon...

In cell J49 you can put: =IF('SheetA'!K49 + 'SheetB'!K49=0,"",K49/I49) and not worry about the formatting. But, all you are doing is working off the original formula which is OK for reporting, but if you need to further utilize data from this page, then you will run into the same issue. Blue...

=A1 & B1 and if you need a space: =A1 & " " & B1 Blue [Dragon] If I wasn't Blue, I would just be a Dragon...

Nice approach Skip, I wrote down the IF/THEN's of where the start and end times would be and the formula would get out of hand in a hurry. Blue [Dragon] If I wasn't Blue, I would just be a Dragon...

I would suggest looking at syslog-ng. It is very good at doing what you are asking for. Blue [Dragon] If I wasn't Blue, I would just be a Dragon...

If I understand your question correctly, you want the total time between the two dates and exclude any time that falls between 0100-0800. If that is correct, you can do difference between the times and exclude 7 hours per day. The caveat is determining if the begin or end times fall within...

Right click on the folder and choose properties. Under the popup chose security and click on the users name. The security settings should be evident on what is required. Blue [Dragon] If I wasn't Blue, I would just be a Dragon...

IS the temp directory that the files are opened in have the appropriate permissions for this user? Blue [Dragon] If I wasn't Blue, I would just be a Dragon...