Time & Activity Tracker Update [Gold & Silver]
Hello Members!
In this week’s Feature, Fix, or Focus, we take last week’s Time & Activity Tracker training.
Here's the list of updates I made for this training:
· Set Task Limits To Current Day requested by Jeyaraj
· Dynamic Weekdays requested by Mbobo
· Add, Update & Delete Customers added by Randy Austin
· Add, Update & Delete Projects added by Randy Austin
Please don’t forget to add your requests for your own Feature, Fix or Focus each week when I post a new video, right here on Patreon. Each week I will either add a new feature, fix a bug or an issue, or create another training with a special focus on any part, all based on your feedback and comments.
Comments (4)
Hello Randy, I was wondering could you tell me how to update the shape height? because we want to use the interval with 3 minutes instead of 15 30 ect... But it seems we like to start at 6:30 PM and shows next 6:33PM So i tried to only add 6:30 PM till 6:30PM But the shape isn't reseizing the height of the current row It show from 6:30 PM till 6:33PM ? can't we update that so we have it the way we want? So we like to only add a tracker just on 1 line Thanks
HI Ian, thanks for your comment. When determining the shape height for a time interval, we must first get the actual value of that interval. So if we have a 3 minutes interval we would start with a full day, which is 1 so 3 minutes would be Interval ==(1/24/60)*3 then lets assume we have a duration of 15 minutes We would make sure to put that 15 minutes in decimal form. (0.0104166) Then we would use division NumberOfCells = Int(0.0104166 / Interval) We would use Int to make sure we are getting the whole Number Then we could set the shape height ShapeHeight = Range(Cells(StartRow,ShapeColumn),(Cells(StartRow + NumberOfCells - 1,ShapeColumn) Something like this should work. The key is to get the number of interval minutes into decimal form then divided that by the total time of the appointment. I hope this helps and thanks so much.
Hello, 1 small thing. I am receiving an error message when opening the "updated.xlsm" file. There is an external link in the workbook and I cannot find it to remove it. The link is to "Ultimate_ERP_Application.xlsm" location "D:\Dropbox\Excel4Freelancer\Free...\Ultimate ERP Application"
Hello Deborah, thanks for your message and letting me know about the link. I did find the link, which was tied to a macro on one of the buttons I used for the Edit Project. You can now download the updated workbook from the post, so thank you for letting me know. Also, to find hidden links, I have been using this great Excel Add-in called FindLinks You can download it from here: https://www.dropbox.com/s/7suenhc0r5gz5ww/findlink.xla?dl=1 (Please make sure to enable macros on download) I hope this helps and thanks so much.