This should be relatively simple, but I cant 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,