So, I am setting up some excel documents to provide me with information about my productivity. I have one where I enter start time and end time…then a cell with a formula to show total time on the job. Then a cell that states the charge for the job performed.
How can I create a formula where I can show total Dollars per man hour for the day…or even by the job and then calculate it for the day.
I know I can do all this the old fashioned way…but I honestly just want to be lazy about it , enter the numbers and let excel do the calculating. I’m sure there are programs I can buy too, but I am not ready to invest in all that yet…I have been sticking to Google Calendar and Quicken online for now.
I know, dumb question…but there must be a formula…I haven’t been able to do a successful Google search.
I figured out how to calculate the hours worked…correct me if I’m wring, but the basic way to calculate dollars per man hour is the money charged on the job divided by the hours worked?..it has to be in tat time function somewhere …considering I am a one man show right now, that seems like the easy calculation…it’s much more complicated for more than one man I would think…I suppose I will just do it the old fashioned…long hand way haha!..I’m learning excel, but I’m not even good enough on it right now to be considered a novice!
Yes, money charged divided by hours worked. It wouldn’t be much harder for multiple people either: just divide money charged by total hours worked.
I use Google sheets so everything stays in Google, but the formula should be something like:
“=C1/(B1-A1)”
This would be without quotes, of course, and assuming A1 is where you entered your start time, B1 your end, and C1 your money charged.
If you wanted, you could make a date column, start, end, charge, and $/hr column. Put the formula in at the top, highlight it, then drag the little square down as far as you want so that it duplicates the formula for each row.
