Hi!

Hmmm.....

That sure is an "interesting" way to keep a timesheet!

I have it in text format

What exactly does that mean?

COUNTIF(F6,"P*")

What are the COUNTIFs counting?

Can you post a sample of your data?

Biff

wrote in message
ups.com...
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) = "0:15",RIGHT(G6,4),0) +
IF(RIGHT(H6,4) = "0:15",RIGHT(H6,4),0) +
IF(RIGHT(I6,4) = "0:15",RIGHT(I6,4),0) +
IF(RIGHT(J6,4) = "0:15",RIGHT(J6,4),0) +
IF(RIGHT(G6,4) = "0:30",RIGHT(G6,4),0) +
IF(RIGHT(H6,4) = "0:30",RIGHT(H6,4),0) +
IF(RIGHT(I6,4) = "0:30",RIGHT(I6,4),0) +
IF(RIGHT(J6,4) = "0:30",RIGHT(J6,4),0) +
IF(RIGHT(G6,4) = "0:45",RIGHT(G6,4),0) +
IF(RIGHT(H6,4) = "0:45",RIGHT(H6,4),0) +
IF(RIGHT(I6,4) = "0:45",RIGHT(I6,4),0) +
IF(RIGHT(J6,4) = "0:45",RIGHT(J6,4),0) +
IF(RIGHT(G6,4) = "0:60",RIGHT(G6,4),0) +
IF(RIGHT(H6,4) = "0:60",RIGHT(H6,4),0) +
IF(RIGHT(I6,4) = "0:60",RIGHT(I6,4),0) +
IF(RIGHT(J6,4) = "0:60",RIGHT(J6,4),0) -
IF(OR(AND(LEFT(G6,1)="L",RIGHT*(G6,4)="0:08",RIGH T(G6,4)<"0:*23"),RIGHT(G6,4)="0:15"),"0:15*",0)

-
IF(OR(AND(LEFT(G6,1)="L",RIGHT*(G6,4)="0:23",RIGH T(G6,4)<"0:*37"),RIGHT(G6,4)="0:30"),"0:30*",0)