Hello,
I am an engineer for a chemical company and do work primarily on projects, and typically I work on multiple projects in a given time frame.
I have to track my hours worked on each project and charge them out to the project using SAP by the end of the month.
I've been using a self-created spreadsheet to track my hours each day, and I'd like to get recommendations to help improve my spreadsheet and make input more efficient.
For each given month (May 2020 shown), I start with all of the weekdays listed for that month (1 row for each cell).
As I work on projects each day, I add a row below, copy and paste the date, and repeat this process until I have enough rows for the days (if I worked on three projects on Friday, May 1st, then I want three rows for that day and I'll enter the name of each project and the hours I work).
This process seems very clunky and inefficient and I assume there's a better way of doing it in excel if someone could help me out. It takes a matter of seconds to enter an extra row, but I'm sure over the course of a year it adds up. Does anyone know if there's any easier way to add new date rows besides this clunky was of insert row then copy and paste the date?
(Note: I intended to attach the spreadsheet but I can't figure out how to do that, I attached a screenshot though instead.)
I am an engineer for a chemical company and do work primarily on projects, and typically I work on multiple projects in a given time frame.
I have to track my hours worked on each project and charge them out to the project using SAP by the end of the month.
I've been using a self-created spreadsheet to track my hours each day, and I'd like to get recommendations to help improve my spreadsheet and make input more efficient.
For each given month (May 2020 shown), I start with all of the weekdays listed for that month (1 row for each cell).
As I work on projects each day, I add a row below, copy and paste the date, and repeat this process until I have enough rows for the days (if I worked on three projects on Friday, May 1st, then I want three rows for that day and I'll enter the name of each project and the hours I work).
This process seems very clunky and inefficient and I assume there's a better way of doing it in excel if someone could help me out. It takes a matter of seconds to enter an extra row, but I'm sure over the course of a year it adds up. Does anyone know if there's any easier way to add new date rows besides this clunky was of insert row then copy and paste the date?
(Note: I intended to attach the spreadsheet but I can't figure out how to do that, I attached a screenshot though instead.)