How can I tell Numbers to calculate my earnings per job, by multiplying my hours worked by hourly rate?

Hi April,

If I understand your question correctly, this may help.

Tested in Numbers for Mac. I am not able to test this on an iOS device.

My brain prefers to break a problem down into small steps, hence the many columns.

Enter your Hourly Rate in Column C. That allows you to change the Hourly Rate for each job if necessary.

Format Columns E and F as Text. Enter Start Times and End Times as 13:00 for example.

Fill these formulas down.

Formula in G2 =IF(OR(E2="",F2=""),"0h",F2−E2)

That will return 0h (zero hours) if either Start Time or End Time are blank. Else it will calculate the Duration (hours) of a job.

Formula in H2 =DUR2HOURS(G2)

That converts a Duration to a decimal number of hours.

Formula in I2 =IF(AND(H2>0,H2<1),1,H2)

That returns 0 for an uncompleted job, rounds up a short job to the 1 hour minimum, or returns the Duration for a completed job .

Formula in J2 =MAX(I2,H2)

Formula in K2 =C2×J2

Formula in Footer Row K8 =SUM(K)

Hide any intermediate columns that spoil your display.

Please test in iOS and call back with questions.

Or refer to this forum iWork for iOS

Regards,

Ian.

Hi April,

You can either type a formula (start with the equals sign) or select a formula in my previous post and Copy. For example,

Make sure that you include the equals sign in the selection.

Click (or tap) on cell G2 and Paste.

As for the SUM in cell K8, make sure that Row 1 is a Header Row and Row 8 is a Footer Row. As you add more Body Rows, the SUM formula will automatically in include them.

If you are still having problems, I can ask our Hosts to move this discussion to the iWork for iOS forum where you will get more expert help.

Regards,

Ian.