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.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I want to do a simple time chart and calculate the labor charge for the time. I can get the amount of hours to charge for, but I cannot create a formula to calculate the labor charge off of the number of hours.
any suggestions?
Hi Cosmopack,
Here's a simple time chart, with calculations.
Ignore the 'add a sheet' box (upper left); I had the pointer in a sensitive place when taking the screen shot.
Column A is left for entering the name(s) of the worker(s).
Starting and ending times are entered in columns B and C respectively. In D2, subtracting the start time from the finish time ( C2-B2 ) returns the duration of the work time in hours and minutes.
The result is presented as a DURATION value (3h 15m), which the DUR2HOURS formula in E2 converts to a decimal number representing the number of hours worked. (3.25)
This number is multiplied by the per hour pay rate of this worker in column 5 using the formula shown below columns E, F and G of the table to show the amount due to the worker for this work period.
Additional rows can be added to do the calculations for more work periods for the same worker, and it that is the only worker handled by this table, Column G can be summed to show the total for this pay period.
Regards,
Barry
DUR2 HOURS convert
E2 (and other active rows of column E contain the DUR2HOURS formula used to calculate the number of hours and minutes worked in the period defined by the time-of-day values in columns B and C.
The result (3h 15m) is a Duration value.
Hi Cosmopack,
Here's a simple time chart, with calculations.
Ignore the 'add a sheet' box (upper left); I had the pointer in a sensitive place when taking the screen shot.
Column A is left for entering the name(s) of the worker(s).
Starting and ending times are entered in columns B and C respectively. In D2, subtracting the start time from the finish time ( C2-B2 ) returns the duration of the work time in hours and minutes.
The result is presented as a DURATION value (3h 15m), which the DUR2HOURS formula in E2 converts to a decimal number representing the number of hours worked. (3.25)
This number is multiplied by the per hour pay rate of this worker in column 5 using the formula shown below columns E, F and G of the table to show the amount due to the worker for this work period.
Additional rows can be added to do the calculations for more work periods for the same worker, and it that is the only worker handled by this table, Column G can be summed to show the total for this pay period.
Regards,
Barry
DUR2 HOURS convert
E2 (and other active rows of column E contain the DUR2HOURS formula used to calculate the number of hours and minutes worked in the period defined by the time-of-day values in columns B and C.
The result (3h 15m) is a Duration value.
Thanks/ exactly what I needed!
You're welcome, Cosmopack.
Regards,
Barry
Calculating labor charge using time function
