Calculating timesheet with COMP TIME

I am trying to design an office time sheet with comp time calculations. I am having a hard time developing the cell formula to use for COMP EARNED. We work a total of 7 hours a day (cell I6 (entered as a number), and if anything is above 7 hours from cell I10 (11, 12, 13, 14 this is where I have the time worked calculated subtracting out our break time, entered as TIME). I want the comp time earned dumped into column J10 (11, 12, 13, 14, etc)

Any help would be greatly appreciated.

Hello and welcome to the forum.

It usually helps us a great deal if you will post a small relevant portion of what you already have. Saves us having to generated data.

To upload an Excel file:

To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

be sure to desensitize the data

• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.