Abrandon73
New Member
- Joined
- Dec 22, 2010
- Messages
- 1
I have one button at the top of my page that I would like to assign a Macro to but my little brain can't grasp how to do it. Please help...<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
My goal is to find out how many hours per month a motor has been running on a particular piece of equipment. I have a data set that is created everyday named by the date. Actually it is a csv file. The files are put in the current year folder. There is one column that either shows a positive value if the motor is on or a zero if it is off. In my main excel spreadsheet I have a column of months; for example January 2010, February 2010 etc... I would like to select any month, hit the button at the top of the page, go to the correct folder, find a particular range of cells, add up the time and return me an hours/min number.<o></o>
<o></o>
One final detail is that my data is taken every 5 min. So each cell represents 5 min.<o></o>
<o></o>
Is this too complicated or can anyone help??<o></o>
<o></o>
My goal is to find out how many hours per month a motor has been running on a particular piece of equipment. I have a data set that is created everyday named by the date. Actually it is a csv file. The files are put in the current year folder. There is one column that either shows a positive value if the motor is on or a zero if it is off. In my main excel spreadsheet I have a column of months; for example January 2010, February 2010 etc... I would like to select any month, hit the button at the top of the page, go to the correct folder, find a particular range of cells, add up the time and return me an hours/min number.<o></o>
<o></o>
One final detail is that my data is taken every 5 min. So each cell represents 5 min.<o></o>
<o></o>
Is this too complicated or can anyone help??<o></o>