Assume you are doing this on row 10 - put this formula in H10:

=FLOOR(MIN(G10,8/24),15/24/60)

and this in I10:

=IF(G10<8/24,0,FLOOR(G10-8/24,15/24/60))

By way of explanation - 8/24 relates to 8 hours (compared with a 24-hour
day), and 15/24/60 relates to 15 minutes.

If you are on a different row, then change G10 as appropriate.

Hope this helps.

Pete

"Bee" wrote in message
...
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!)