D

#### draculardw

attempting to formulate. I am trying it a lot of different ways sometimes

formula errors sometimes not, but still no results in the cell. This has to

do with payroll calculations. Here is what I have so far that works!

cells []

[09:00] - [23:00] = [14.00] this works ie: =SUM((B10-A10)*24)

This is what I need help on

If I am working on the clock at 15:00 I get a shift differential for those

hours beyond 15:00 hours until I clock out, so lets say from the above

example. I would be payed for 14 hours at my regular rate then get a diff

from 15:00 - 23:00 which is a difference of 8 hours

I cannot seem to come up with a formula that will allow me in another cell

to calculate the two time differences and anything greater than 15:00 place

in that cell the total hours of 8

any help thanks

Richard