=if(StartTime
TimeValue("16:00"),Mod(EndTime-StartTime,1),if(EndTimeTimeValue("16:00"),En
dTime-TimeValue("16:00"),0))

--
Regards,
Tom Ogilvy


"Aaron H" wrote in message
...
Tom Ogilvy wrote:
What are the possibilities?

Can all the work time be after 1600 (start and end time after 1600)
and if
so, can the time cross midnight. Or will start time always be before
1600
and end time may sometimes be past 1600, but never past midnight.

Do you want a formula to use on each row?

Can work before 16:00 (start and and after)
time won't cross midnight
Will not always start before 1600

This is to calculate a penalty rate for working wages. before 1600
wage = $10, after 16:00 $10 + 25%. Similar on Weekends, but standard
penalty through the whole day.

I have the start time in a cell and end next to it. both have a series
of selectable times.

Idea is to create the roster and from roster generate wages.


Thanks
Aaron