For an 8 hour day

=MIN(ROUND((B1-A1)*96,0)/96,TIME(8,0,0))

gives regular time, and

=MAX(0,ROUND((B1-A1)*96,0)/96-TIME(8,0,0))

gives overtime

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Don" wrote in message
...

This should be relatively simple, but I can't figure it out.

The function has to be setup in one cell.

First; the function needs to figure how many hours you worked from the
beginning time to the ending time.

Second; the hours worked has to be split into normal working hours and
overtime. The hours an employee can work obviously varies between full
and
part-time employees, but there can not be a vlookup on the timesheet.
Although a vlookup on another worksheet in an excel workbook is
acceptable.
Overtime hours will trickle off the remaining time into the next column.

Finally; this is all based on quarter hours. So the entire function has
to
be rounded. I know how to use the round function, but, I can only use it
in
simple problems right now.

Whenever someone has the time to help me; thanks.

Don,