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!

  • Congratulations Mike Lewis 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. addicted2

    Calculate time PLEASE HELP

    No probs Loomah.. The assistance I have recieved has been over whelming. Thankyou all very much. I have tried everyones approach to the problem and they have all been great from each one I have learnt a little somthing.
  2. addicted2

    Calculate Amount of time worked.. Help stop me working for nothing

    wow So much Info Thanx heaps to all of you for your time. Fantastic.
  3. addicted2

    Calculate time PLEASE HELP

    THANKYOU THANKYOU Glen that is exactly what I needed.
  4. addicted2

    DSI Convert Minutes to hours and minutes

    Sorry DSI i have realy explained that bad. What I want to do is convert the minutes that I have worked into hours and minutes. I have for example 405 minutes but when I divide that by 60 I get 6.75 What I would like to get is 6.45( 6 hours and 45 minutes) I feel like such a dope.
  5. addicted2

    Calculate Amount of time worked.. Help stop me working for nothing

    DI Sorry I have explianed it real bad. No what I am trying to do is convert the minutes that I have worked to hours and minuts. When I enter 405 and divide that by 60 to get the time I worked the answer that I get is 6.75. What I am trying to get is 6.45.. Representing 6 hours and 45 minuts
  6. addicted2

    Calculate Amount of time worked.. Help stop me working for nothing

    Hi there can some one help me please. I work different hours each day of the week and I cant seam to find how to calculate these hours to ensure that I do 40 hours a week and show If if i do over the 40 hours Please bear with me and I will try to explain A)CELL A1 40 (representing the hours)...
  7. addicted2

    Calculate time PLEASE HELP

    HELLLLLPPPPPP. Hi there can some one help me please. I work different hours each day of the week and I cant seam to find how to calculate these hours to ensure that I do 40 hours a week and show If if i do over the 40 hours Please bear with me and I will try to explain A)CELL A1 40...
  8. addicted2

    Lets see if this stumps you. I need some code to list the contents of

    Lets see how you go here. I need some code that will collect all the worksheet names from several workbooks that reside in serveral subfolders That are in a folder on C: called house hold. Sorry but i can think of no easier way to explain it. If you refer back to my last thread posted 2 days ago...
  9. addicted2

    Masters Of The VBA universe I have another Question

    Yes That it is a good idea Skip to put the code in the adjasent coloumn. The List well If I am doing this right I hope to use the list for 2 purposes 1. to populate a list box that will be used when the folder is udated. and 2. To trap errors so that the name is not entered in twice. Thats it...
  10. addicted2

    Masters Of The VBA universe I have another Question

    OK i have a folder on C: called HOUSEHOLD within this folder I have several subfolders and within these subfolders I have a minimum of 3 xls files. So that I can populate a listbox and trap errors I need assistance with a code that will Search all the subfolders and fill column c of the active...
  11. addicted2

    RE Dalewaston 123321 response to wuwang

    People who have not offered stars to the kind people who offer advice,tips and codes. Should read the coments made by Dalewatson123321 when he helped wuwang with some code. I have only used this site for a few weeks and in that time I have found the help to be extremely valuable and appreciate...
  12. addicted2

    Display a list of FOLDERS in Column A

    Hi,can anyone show me a code that will lookin C:Household and display a list of it's sub folders in Column A of the active worksheet. Thanks all B-) Cheers Tony
  13. addicted2

    [color green] THANKS EVERY ONE/COLOR

    Being a newbie to programming and even after purchasing books VBA has been exciting yet overwhelming. To have a site like this has been great for me. The assistance and the promptness at which I have recieved the assistance has been fantastic. I hope that latter down the track I will also have...
  14. addicted2

    Thanx Skip&VbMax - 1 more ?- I need To Search C for the folder

    Thankyou heaps for your help people "RE:I need to create a folder in c:" was great and fast. I have another situation that I need help with once a name has been entered into the input box and before it creates a new folder is there a code that will search C:Household to make sure the...
  15. addicted2

    create a new folder VBA Excel

    G'day all. if someone can help I would greatly appreciate it. I need a code that will:- Go to c drive open a folder called household then Create a NEW FOLDER that will be renamed to a name chosen by the user ( maybe via an input box). I am writting this code for a local Community House where...
  16. addicted2

    create a new folder VBA Excel

    G'day all. if someone can help I would greatly appreciate it. I need a code that will:- Go to c drive open a folder called household then and a NEW FOLDER that will be renamed to a name chosen from the user ( maybe via an input box).

Part and Inventory Search

Back
Top