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.
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.
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
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)...
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...
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...
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...
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...
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...
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
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...
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...
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...
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).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.