Auto add time up and cost
I have a spreadsheet that has dates, the amount of time spent each day and the cost per hour and minute for each amount of time spent working on a project. Kind of like a timer sheet.
I would like to know if there is a better way to:
add the TIME INVOLVED to auto calculate the TOTAL HOURS
Take the TOTAL HOURS and calculate them by 5.555 (333.33 an hour = 5.555 a minute)
Then the number from MINUTE auto-calculates the COST.
Thank you in advance
|