calculating sales per labor hour as of current time.

Rob,

Short Answer: =(V2-A21)*24 is the formula you're after.
Explanation:
The trick to solving this problem is understanding that Excel treats times as fractional parts of a day. For instance, at 8:00 AM, we've traversed 1/3 of a day (starting from midnight), thus 8:00AM = .33. Noon is .5, and 11:59 PM is almost 1.

If you format V6 to a number (you can add decimal places if you'd like), enter the formula: =(V2-A21)*24 -- that assumes that each day starts at 7:00AM (b/c A21 has time: 7:00 AM). For your example where V2 is 3:00 AM, the difference between 7 & 3 is 8 hours so you get .33 -- multiply by 24 hours/day to a decimal representation of day and the units of day cancel and you're left with hours. Then when you enter your units sold, you get expected SPLH results, as you've defined it.

Hope this helps,

Joe

PS Instead of entering the time, you can enter: =MOD(NOW(),1) into V2, and then re-calculate the sheet as-needed -- that, in a sense, extracts the measured time off the beginning of the day. Then re-format cell V2 so it displays time.

If you read the previous version of this post (before I edited it), please ignore the response.

Use formula: =SUM(W21:INDIRECT("W" & INT(MATCH(V2,A21:A36)-1+21))) in cell V6.

-Note: this solution will work with the =mod(Now(),1) formula in cell: V2 and will round to the nearest hour. That is, if it's 3:59 or 3:00 or 3:01 (PM), it will give you the same result.
Also Note: This solution will give you the same result for any time after 10:00 PM (the last element of range A21:A36) and before 12:00 AM
Also Note: This solution will give an #N/A result if a time before 7:00 AM is entered

Originally Posted by Alexwog2018

Hey Robt1973!

I find your table to be of Great use, but I would like to add more workers. Could you explain how to enlarge the table without Messing up the formulas. I am a beginner excel user. I need to include 30 workers.
Thank you in advance, I know this thread is very old, but hopefully this Messages reaches you.

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread