Making a time tracking application in excel Part 2 - Woodworking Talk - Woodworkers Forum
 
Thread Tools Display Modes
post #1 of 7 Old 08-07-2016, 11:27 AM Thread Starter
Member
 
Join Date: Oct 2014
Posts: 77
View Scott Marshburn's Photo Album My Photos
Making a time tracking application in excel Part 2



Follow along with me and learn how you can make a time tracking application in excel.
In
video, we will be declaring and setting public variables that will allow us to use them throughout the project. If you have not downloaded the workbook be sure to click on this dropbox link so you can follow along.
`If you are not familiar with variables and variable scopes then. Be sure to check out Trever Easton’sVideo on variables here VBA for Beginners - VBA Variables Explained Simply

Subscribe → https://www.youtube.com/user/ecabine...confirmation=1
You can also follow me on:
Facebook→ https://www.facebook.com/ecabinetstipsandtricks
Twitter→ https://twitter.com/eCabinetstips

-- Scott Marshburn,https://www.youtube.com/user/ecabinetstips, FaceBook, https://www.facebook.com/ecabinetstipsandtricks, Twitter, https://twitter.com/eCabinetstips

Last edited by Scott Marshburn; 08-07-2016 at 11:29 AM.
Scott Marshburn is offline  
Sponsored Links
Advertisement
 
post #2 of 7 Old 08-07-2016, 02:07 PM
Senior Member
 
Join Date: Jul 2008
Location: Florida Panhandle
Posts: 12,266
View GeorgeC's Photo Album My Photos
What type/kind of time would I be tracking?

George
GeorgeC is online now  
post #3 of 7 Old 08-07-2016, 08:22 PM Thread Starter
Member
 
Join Date: Oct 2014
Posts: 77
View Scott Marshburn's Photo Album My Photos
Hi. George. When this application completed you will be able to track the time that you spend on any stage of your projects. In future videos. I will be demonstrating how to make the tools needed to assign task as well as employees and their pay rates. I will also show you how to generate reports from the data that is collected to help in creating accurate time estimates for similar projects.
Scott Marshburn is offline  
Sponsored Links
Advertisement
 
post #4 of 7 Old 08-07-2016, 08:39 PM
Senior Member
 
Join Date: Jul 2008
Location: Florida Panhandle
Posts: 12,266
View GeorgeC's Photo Album My Photos
Ah So. You want to sell commercial software.

George
GeorgeC is online now  
post #5 of 7 Old 08-07-2016, 08:50 PM Thread Starter
Member
 
Join Date: Oct 2014
Posts: 77
View Scott Marshburn's Photo Album My Photos
I am not necessarily looking at selling this. Just trying to offer some of my Knowlege to others that may be interested in learning how to do something like this.
Scott Marshburn is offline  
post #6 of 7 Old 08-08-2016, 08:02 AM
Senior Member
 
TomCT2's Avatar
 
Join Date: May 2014
Location: Central PA
Posts: 1,303
View TomCT2's Photo Album My Photos
. . . doing "clock / time" calculations in Excel made my head hurt.

and entering times was extremely error prone. if somebody didn't put in the colon hh:mm (assuming they know what a 24 hour clock is) - or left out the am/pm notation the whole thing blew up....how did you solve that ?
TomCT2 is offline  
post #7 of 7 Old 08-08-2016, 03:40 PM Thread Starter
Member
 
Join Date: Oct 2014
Posts: 77
View Scott Marshburn's Photo Album My Photos
Hi Tom. In future videos, I will be showing how to overcome these issues. Pretty much I will be using a user form for entering Times manually like the one in this photo
Attached Images
 
Scott Marshburn is offline  
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the Woodworking Talk - Woodworkers Forum forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Similar Threads
Thread Thread Starter Forum Replies Last Post
Making a time tracking application in excel Scott Marshburn Woodworking Videos 0 07-20-2016 08:15 AM
Introduction to Creating a Time tracking workbook with excel Scott Marshburn Woodworking Videos 2 06-17-2016 09:36 AM
Formatting eCabinets Five Piece Door Breakdown with excel Part 4 Scott Marshburn Woodworking Videos 0 02-20-2016 09:21 AM
Formatting eCabinets Five Piece Door Breakdown with excel Part 3 Scott Marshburn Woodworking Videos 0 01-10-2016 09:04 AM
Formatting eCabinets Five Piece Door Breakdown with excel Part 2 Scott Marshburn Woodworking Videos 0 01-02-2016 11:20 AM

Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

 
For the best viewing experience please update your browser to Google Chrome