I need a simple time tracker creating in Excel.
the spreadsheet needs to have a list of resources which will be booked out and charged per the time they're booked out.
The layout will have a column of the resources listed, a column with the time counter that displays the duration/time that the resource has been booked for, a column that calculates the cost of the booking, and 3 buttons to start the booking, stop the booking and a button to clear the cell that holds the duration/time cell.
The cell that displays the cost of the booking will reference the cell that displays the duration/time and calculate the total cost against a 'lookup' cell that holds the cost per minute (or second if that's easier to calculate from).
I will provide more details and mock up of the spreadsheet, without any vba, to illustrate how I'd like the sheet to look.
Please inbox me for more information
Such jobs are my daily practice. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. When considering the delivery time in my bid please take into account that job specification is not yet completed, and the design phase of a project comes out at a very significant percentage of the total completion time! Regards!