I keep time on a project that has more than one job. Example:

Mike Mon Tue Wed Thur Fri

Alky 6 6 6 6 6 = 30
Shu 2 2 2 2 2 = 10
Chfu 2 2 2 2 2 = 10
--------------------------------------------------
10 10 10 10 10 50

On my summary sheet, I already have a formula to break out the 10 OT hours.

Mike ST OT
40 10

What I need is a formula to calculate OT on a daily basis for each project
and put it into a seperate OT column.

Mike Mon Tue Wed Thur Fri
ST OT ST OT ST OT ST OT ST OT ST OT
Alky 5 1 5 1 5 1 5 1 5 1 = 25 5
Shu 1.5 .5 1.5 .5 1.5 .5 1.5 .5 1.5 .5 = 7.5 2.5
Chfu 1.5 .5 1.5 .5 1.5 .5 1.5 .5 1.5 .5 = 7.5 2.5
-------------------------------------------------------------------
10 10 10 10 10 50=40 10

Something like that. we have to break out & charge overtime to individual
jobs, instead of all to one.

I'm so close, but I am just missing the mark.