Recent content by FYRGUY47

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

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

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

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

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

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

I will read through it Skip... Thanks Chris

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

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

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

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

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

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

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

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