Aaron,

Assuming your end times are in B1:B100, try

=SUMPRODUCT(--(B1:B100--"16:00:00"),(B1:B100-"16:00:00"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Aaron H" wrote in message
...
I have created a time roster.. easy
in each day I have start,end and break deduction.. still no probs

I need to create an output formula for hours worked after a 16:00 from
the start and end range on a day. So in the roster it will still display
normal hours, however I will create a field for hours after 16:00. this
is for calculating a different wage rate.

Thanks Aaron