I am trying to get my spreadsheet to calculate hours paid for an
employee but I need it add overtime and subtact how late they were as
well. I have it in text format and need it to calculate in time
format. I am also trying to get it to read each cell. Is there any
way I can get to read each cell and calculate the time.


The formula you see here is what I am using.


COUNTIF(F6,"P*")/6 +
COUNTIF(G6:J6,"p*")/4.8 +
COUNTIF(G6:J6,"eh*")/4.8 +
COUNTIF(G6:J6,"mu*")/4.8 +
COUNTIF(G6:J6,"l*")/4.8 +
COUNTIF(G6:J6,"el*")/4.8 +
IF(RIGHT(G6,4) =3D "0:15",RIGHT(G6,4),0) +
IF(RIGHT(H6,4) =3D "0:15",RIGHT(H6,4),0) +
IF(RIGHT(I6,4) =3D "0:15",RIGHT(I6,4),0) +
IF(RIGHT(J6,4) =3D "0:15",RIGHT(J6,4),0) +
IF(RIGHT(G6,4) =3D "0:30",RIGHT(G6,4),0) +
IF(RIGHT(H6,4) =3D "0:30",RIGHT(H6,4),0) +
IF(RIGHT(I6,4) =3D "0:30",RIGHT(I6,4),0) +
IF(RIGHT(J6,4) =3D "0:30",RIGHT(J6,4),0) +
IF(RIGHT(G6,4) =3D "0:45",RIGHT(G6,4),0) +
IF(RIGHT(H6,4) =3D "0:45",RIGHT(H6,4),0) +
IF(RIGHT(I6,4) =3D "0:45",RIGHT(I6,4),0) +
IF(RIGHT(J6,4) =3D "0:45",RIGHT(J6,4),0) +
IF(RIGHT(G6,4) =3D "0:60",RIGHT(G6,4),0) +
IF(RIGHT(H6,4) =3D "0:60",RIGHT(H6,4),0) +
IF(RIGHT(I6,4) =3D "0:60",RIGHT(I6,4),0) +
IF(RIGHT(J6,4) =3D "0:60",RIGHT(J6,4),0) -
IF(OR(AND(LEFT(G6,1)=3D"L",RIGHT=AD(G6,4)=3D"0:08 ",RIGHT(G6,4)<"0:=AD23"),=
RIGHT(G6,4)=3D"0:15"),"0:15=AD",0)

-
IF(OR(AND(LEFT(G6,1)=3D"L",RIGHT=AD(G6,4)=3D"0:23 ",RIGHT(G6,4)<"0:=AD37"),=
RIGHT(G6,4)=3D"0:30"),"0:30=AD",0)