calculating time with the form of text

[jfhdez1a]

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",RIGHT(G6,4)<"0:­23"),RIGHT(G6,4)="0:15"),"0:15­",0)

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

 

[Dodo2u]

(e-mail address removed) wrote in

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've made an example. Give me an address and I will E-mail it to you.

My Excel version is Dutch so I have to provide some functional translation.

 

[jfhdez1a]

you can send it to my yahoo account or to me at work.
(e-mail address removed)

 

[Dodo2u]

(e-mail address removed) wrote in @g44g2000cwa.googlegroups.com:

you can send it to my yahoo account or to me at work.
(e-mail address removed)

Done, to both addresses!

If any probs, let me know!