You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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

Posted on Jun 8, 2020 11:44 PM

Reply
Question marked as Top-ranking reply

Posted on Jun 9, 2020 2:37 AM

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.


2 replies
Question marked as Top-ranking reply

Jun 9, 2020 2:37 AM in response to Smi_c

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.


Creating timesheet/invoice

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.