I've reviewed numerous posts on timesheets and cannot find what I need. If
you can help, please do.

Cell G totals daily time logged in (in, out, in, out) from times entered in
cells A thru F. This part I got. I want cell H to display only the hours up
to and including "08:00" --- rounded DOWN to the nearest quarter hour. Any
excess time (over 8 full hours) I want displayed in cell I --- also rounded
DOWN to the nearest quarter hour. Ex: If G displays a total of 09:40 (9
hours 40 mintues), I want cell H to display 08:00 and cell I to display
01:30; if G displays only 06:25, I want H to display 06:15 and cell I to
display 00:00.

(This was even complicated for me to explain let alone know how to make it
happen!)