Creating timesheet/invoice
Hello,
I run a business where I charge an hourly rate. I am wanting my timesheet to work out the total price from the hours and hourly rate?
MacBook Air 11″, 10.15
Hello,
I run a business where I charge an hourly rate. I am wanting my timesheet to work out the total price from the hours and hourly rate?
MacBook Air 11″, 10.15
Hi Smi_c,
Take a look at Template Chooser > Business > Employee Time Sheet.
Here is a simpler approach for a single employee.
Formula in E2 =D2−C2
Column E is formatted as Duration
Formula in F2 =E2×Hourly Rate::A$1
Column F is formatted as Currency.
Fill the formulas down.
Please call back with questions.
Regards,
Ian.
Hi Smi_c,
Take a look at Template Chooser > Business > Employee Time Sheet.
Here is a simpler approach for a single employee.
Formula in E2 =D2−C2
Column E is formatted as Duration
Formula in F2 =E2×Hourly Rate::A$1
Column F is formatted as Currency.
Fill the formulas down.
Please call back with questions.
Regards,
Ian.
Wow thank you so much! I’ve been trying for over a week and posted here as a last resort before heading back to excel which I really didn’t want to do 👏🏻
Creating timesheet/invoice