Time sheet for hours worked

Could I just give you a few words of encouragement, based on (believe it or not) 50 years of working with arrays of data, most of that time with spreadsheets as the primary tool.

You don't ever need to "hope" that there's a formula to get from A to B. Quite seriously. A rule of thumb that I developed many years ago, first for myself, then for others who were still learning: IF you find yourself thinking along the lines "Excel should be able to ________" THEN you can be confident that the programmers have indeed made it possible. The challenge is to find the function or functions that make it possible.

Related to that rule of thumb is the reality that you do need to find a comprehensive and clear way to describe the situation, thinking of these three stages: input, process, output. Rather than kicking yourself for "not sure how to word everything" think of it as describing, especially describing fully the process aspect. And focus on describing in plain English (no need to try to translate into "computerese" or "Excel functions"; that comes later).

Usually, once you've described the input, process, and output--your original description here had the first and last parts of that trio; it just left vague the process itself--it becomes relatively easy to find an Excel solution because the names of the functions themselves are close enough to English descriptions of what they do that you can go down a comprehensive list of functions and start playing with them to see if they get you from A to B.

Let me also underscore my use of the word "play" in that last sentence. Give yourself permission to go through trial and error. Play. You won't break anything and you will learn.