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

    Excel Conditional Formatting

    Thanks Skip! That's exactly what I was looking for. I appreciate the help on this! Enkrypted A+
  2. Enkrypted

    Excel Conditional Formatting

    Hello, I've looked through the FAQ's and past threads regarding conditional formatting, but can't seem to get my sheet working properly. I have a spreadsheet where certain cells are listed as =TODAY(). For example, cell A4 is formatted as =TODAY(), cell A5 is formatted as =TODAY()+1, cell A6 is...
  3. Enkrypted

    Microsoft Excel - COUNTIFS Calculation / Count By Hour

    That did the trick. Thanks again Skip!! Enkrypted A+
  4. Enkrypted

    Microsoft Excel - COUNTIFS Calculation / Count By Hour

    I'm sorry, I guess I don't understand what you mean by adding 1 to the times. Can you elaborate on that a little? Enkrypted A+
  5. Enkrypted

    Microsoft Excel - COUNTIFS Calculation / Count By Hour

    Thanks Skip! That worked. I do have one more question, but how would I factor this for someone that works overnight, such as the highlighted portion on the attached file. It should calculate the 10:00PM and 11:00PM for Friday and then the remainder (from 12:00AM to 7:00AM) on Saturday? That was...
  6. Enkrypted

    Microsoft Excel - COUNTIFS Calculation / Count By Hour

    Thanks for this info Skip I applied the name range as you mentioned above and put the above code in P2 as mentioned. When it applied that, it's erroring out with a #REF. I'm not sure if I'm missing something or not. I've attached the updated file if you or someone want to look at it. Thank you...
  7. Enkrypted

    Microsoft Excel - COUNTIFS Calculation / Count By Hour

    I've attached the Excel file. Sorry about that Enkrypted A+ https://files.engineering.com/getfile.aspx?folder=f1b1253b-5b3c-42b1-849b-f8fecd7e0a57&file=File.xlsx
  8. Enkrypted

    Microsoft Excel - COUNTIFS Calculation / Count By Hour

    I have a spreadsheet that I'm trying get a count by hour breakdown on. It contains a list of people and their shift times and days worked: I'm trying to get it to only count those that are working on a particular day (such as Friday). The COUNTIFS code I have works and it calculates the count...
  9. Enkrypted

    Excel - Add new row/increment

    Thanks Skip! I was able to get everything sorted as needed. Much appreciated for your assistance! Enkrypted A+
  10. Enkrypted

    Excel - Add new row/increment

    This is definitely what I'm looking for and it does just as you described, however the problem I'm running into is the results are not staying sequential. When I run the macro with the first line entered as such The results turn out like this However when adding additional lines under the...
  11. Enkrypted

    Excel - Add new row/increment

    No column headers will be ignored. Original data will be pasted on sheet 2 starting on A1 and will be duplicated on sheet 1 starting on A1 as well Enkrypted A+
  12. Enkrypted

    Excel - Add new row/increment

    Gotcha. It needs to have the information duplicated four times as it gets uploaded to a system that will have other applications (4 apps) use it for ID's within each system Enkrypted A+
  13. Enkrypted

    Excel - Add new row/increment

    Sorry, it's been awhile since I've posted. What do you mean by business case? As for the column headers, I don't have any specific header information set yet. Enkrypted A+
  14. Enkrypted

    Excel - Add new row/increment

    Hello, I'm looking for a macro that will automatically add a new row(s) based upon values being presented in a set of columns/rows, when the macro button is clicked after pasting the information in the cell ranges. I have a set amount of columns that data can be pasted into. The range of data...
  15. Enkrypted

    SendKeys % Symbol

    I know with SendKeys that the use of the % sign will process it as "ALT", but is there any way to get SendKeys to actually process a percent symbol as a percent symbol? I have a SendKeys line that contains a percent symbol in the keys it's trying to send, but it's processing as the ALT button...
  16. Enkrypted

    Access Report Control display Form Variable

    Thanks PHV! This works great! Appreciate the help! Enkrypted A+
  17. Enkrypted

    Access Report Control display Form Variable

    This works. Thank you! If I want to add the End Date with that, would it be: =[Forms]![FormWithTwoFields]![StartDate]![EndDate] Enkrypted A+
  18. Enkrypted

    Access Report Control display Form Variable

    I have a report with a text control on it currently set to display the date ( =Date() ). I was wondering how I can replace that with information entered into a field on my form. Example: I have a form with two fields labeled StartDate & EndDate. On my report, I want to subsitute the =Date()...
  19. Enkrypted

    SQL Query Date Variables

    Thank you. That helped out alot! Enkrypted A+
  20. Enkrypted

    SQL Query Date Variables

    I have the following code: SELECT OptionsValues.AgentAssisted, OptionsValues.CurrentDate, OptionsValues.Duration FROM OptionsValues WHERE OptionsValues.Cable Is Not Null -- Bigger or equal of startdate AND OptionsValues.CurrentDate >= '20140421' -- Smaller...

Part and Inventory Search

Back
Top