I require a formula that will break down daily hours worked into rate categories

[Mumma B]

I require a formula that will break down daily hours worked into rate categories eg Normal Time, Time & Half, Double Time.


eg. Column E = Total time worked
Column F = Normal time
Column G = Time & Half
Column H = Double Time

What I would like to do is enter hours into Column E and a formula in Column F will split of hours to a maximum amount of 7.6hrs then the remainder of the hours be placed in Column G to a maximum of 2 hours and Column H, no maximum.


Example:

E F G H
10 7.6 2 .4
10.5 7.6 2 .9

[ConneXionLost]

Try these:

column F

Please Login or Register  to view this content.

column G

Please Login or Register  to view this content.

column H

Please Login or Register  to view this content.

Cheers,

[Mumma B]

Thank you, worked perfectly.

[Mumma B]

Thought it was perfect but not quite there.

I require Column F to be zero if an amount is not entered into Column E. Calculation in columns F, G & H only needs to occur if column E has a number greater than zero entered into it.

How do I adjust the formula in Column F to accommodate this.

[ConneXionLost]

Try this:

Please Login or Register  to view this content.