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

    Any way to crack a locked "workbook"

    Gavona, Thanks for the thoughts. I did google it after you mentioned it and found a download to get in. I now have saved the workbook under my password. Thanks kjv1611, This workbook is a basic budget sheet that we are using currently. each person has their own sheet and some of the...
  2. FYRGUY47

    Any way to crack a locked "workbook"

    Hello everyone, Using Excel 2002, I created a workbook with 30+ sheets/tabs. Each employee has a specific sheet that they are responsible for entering data which in turn reports back to sheet one labeled "Overview" Each employee was instructed to protect their "sheet" when done and save the...
  3. FYRGUY47

    Coverting Days & Hours

    Okay, I think I got it now, thanks You always make me think.... Thanks Skip. Chris
  4. FYRGUY47

    Coverting Days & Hours

    Skip, That formula didn't do it. The return on my 8.70 days returned "8 16" with your formula. FYI - The much earlier post that xlhelp posted is working perfect, I was just interested in learning a cleaner formula if there was one. Thanks for your time Chris
  5. FYRGUY47

    Coverting Days & Hours

    Sorry Skip, my reading of the link you sent did nothing for me. Your post helped... Thank you. I think you posted while I was reading. Thanks
  6. FYRGUY47

    Coverting Days & Hours

    Sorry Skip, That did nothing for me... I knew most of that. Am I missing something..... Chris
  7. FYRGUY47

    Coverting Days & Hours

    I will read through it Skip... Thanks Chris
  8. FYRGUY47

    Coverting Days & Hours

    Skip & xlhelp, Thanks for all your help today and in the past.... I am very interested in what formula you would suggest for my scenereo. I tried earlier not to add in additional information that I thought would be useless information. I tried to get to the point. I thought that I had all...
  9. FYRGUY47

    Coverting Days & Hours

    xlhelp... That is exactly what I needed! We do work a 24hr work schedule. Perfect! Thank you!! Chris
  10. FYRGUY47

    Coverting Days & Hours

    Here is a copy of what it is showing me... 12.00 12 days4.8 hours 12.00 12 days4.8 hours 9.00 9 days21.6 hours 9.00 9 days21.6 hours 12.00 12 days4.8 hours 3.00 3 days7.2 hours 12.00 12 days4.8 hours 12.00 12 days4.8 hours 3.00 3 days7.2 hours 10.30 10 days2.4 hours 9.00 9 days21.6 hours The...
  11. FYRGUY47

    Coverting Days & Hours

    Thank you... I have several rows that will need to be calculated... On rows that have "9.0" days on my sheet, your calculation takes it to "9 days21.6 hours" The same similar thing happens with 12.0 days = "12 days4.8 hours" etc..... Your thoughts....? thank you
  12. FYRGUY47

    Coverting Days & Hours

    Using Excel 2002. I have 10.3 days on a sheet. I am looking for an equation that would convert the 10.3 days to "10 Days" and "x" hours. We work under a 24hr schedule and are trying to calculate vacation days. Thank you Chris
  13. FYRGUY47

    Locking header row for "data sort"

    John, Not sure how to do the quote thing, so I copied and pasted. "I've never seen that behavior. Do you mean that, instead of pressing one of the 'quick sort' buttons (labeled with AZ or ZA and down arrows) you're going to Data > Sort and selecting Header Row?" Anyhow, yes that is exactly...
  14. FYRGUY47

    Required entry in a cell?

    Skip, It is as simple as this: I made a apparel order form for our employee's. In the cell "G2" I created a drop down list of all employee's names, however in the actual cell, I have "Your Name Here". The thought was they would use the drop down list to insert their name. Wellll, they seem to...
  15. FYRGUY47

    Locking header row for "data sort"

    Gavin, Thank you...! I typically just select any one cell in the column and use the sort button on the top of the excel tool bar to sort a particular column. I inserted a empty row below the header and it worked perfectly. Thanks again! That one had been driving me crazy Chris
  16. FYRGUY47

    Locking header row for "data sort"

    Greetings: Using Excel 2003, I have a spreadsheet that I need to sort and keep the header row in place. I typically do not have a problem keeping the header row in place during the sort, however at times I have received sheets from different people that I can't isolate the header row during the...
  17. FYRGUY47

    Seperate address numbers & street text

    Your right... thanks Skip
  18. FYRGUY47

    Required entry in a cell?

    That does help, thank you. I will need the VBA code...
  19. FYRGUY47

    Required entry in a cell?

    Thanks for the reply, I think I am missing something. I unchecked the "ignore if blank" box, saved the workbook, even proteced the sheet, and still are able to go out of the cell without any warning Chris
  20. FYRGUY47

    Required entry in a cell?

    Hello, Using Excel 2003 & Excel for Mac 2008. Can I make a cell required to have an entry? I have a cell that has a "data validation" list, I have the error code set to "stop" and have filled out the actual stop message. Can I make it so the person filling out the form has to enter a name...

Part and Inventory Search

Back
Top