Maintenance Downtime Tracker

[mlee1]

Hello,

First off I would like to say I am very new to macros and VBA in excel. I am trying to create a database that will log and track when our equipment is taken out of service and back in service. I would like for when my techs take a forklift out of service they click on the lift number then themselves and out of service. this in turn will record that lift number who worked on it and a time stamp of when it was taken out of service on sheet2 of the work book. Then when they click in service it adds that time stamp to that same lift. I just have no idea how to create that.

 

[mlee1]

Re: Maintenance Downtime Tracker help

After looking further, it appears that it is stuck on line 322 and will not collect anything past that point. I changed teh F4 cell formula to range to cell 1000 as i will continue to add data to this sheet which then populated the correct number of records however the last seven just populate as #NUM . I also changed cell B7 and down to 1000 and that corrected the issue of not calculating all the downtime hours, i just cannot get the records to show. If i change cells E-M to collect down to cell 1000 it populates data from 3/21

 

[RasGhul]

Re: Maintenance Downtime Tracker help

So do you want your register rows to calculate from Operational times or Out of Services times?

In the array formula this bit SMALL(IF('Downtime Data'!$E$2:$E$322 from my mock up is looking at the Out of Service times.

I can also change these over to table format to make the table dynamic.

 

[RasGhul]

Re: Maintenance Downtime Tracker help

Update your current Downtime Data onto this new version, the data is now on a table so that the DOD formulas are now dynamic.

Note that some of the rows from 09/04 have blanks which should be updated to calculate properly.

https://www.dropbox.com/s/xk8n8t8fkni0cfx/Forklift Service Log_v2.xlsm?dl=0

 

[mlee1]

Re: Maintenance Downtime Tracker help

This works perfectly thank you again for your help!