Splitting diffrent hrs for diffrent rates

[Charlene Durand]

Hi all,

I have a timesheet which we do our daily hrs tracking.

we have diffrent pay rates and there for i want my time tracking to show me diffrent sections this is the formula at the present moment but it calculates all:

=SUMIF(TimeLog!$A$20:$A$2146,"=YES",TimeLog!$G$20:$G$2147)

i now need it to break down to the following hrs

100 HRS:
OVER 100 HRS:
OVER 150 HRS:

 

[Legacy 143009]

Hi all,

I have a timesheet which we do our daily hrs tracking.

we have diffrent pay rates and there for i want my time tracking to show me diffrent sections this is the formula at the present moment but it calculates all:

=SUMIF(TimeLog!$A$20:$A$2146,"=YES",TimeLog!$G$20:$G$2147)

i now need it to break down to the following hrs

100 HRS:
OVER 100 HRS:
OVER 150 HRS:

Ok then, take this term in to IF clauses:

=IF((SUMIF(TimeLog!$A$20:$A$2146,"=YES",TimeLog!$G$20:$G$2147))<=100,"100 HRS",IF((SUMIF(TimeLog!$A$20:$A$2146,"=YES",TimeLog!$G$20:$G$2147)>100,"OVER 100 HRS",IF((SUMIF(TimeLog!$A$20:$A$2146,"=YES",TimeLog!$G$20:$G$2147))=>150,"OVER 150 HRS")))

 

[Charlene Durand]

Hi this formula is not working not sure why

 

[Legacy 143009]

Hi this formula is not working not sure why

But did you get the idea?

 

[Charlene Durand]

yes i did thanks