Hello,

I am trying to create a sheet for use in my work. So far I have a schedule base that allows me to calculate my scheduled hours based on my input. It will total my hours including lunches. Down in the bottom it will calculate hours use per hour and give me a visual of where my hours are used. I have it calculate the hours used per hour. What I would like to do is when I enter in the current time it will return the total hours used up to the current time entered. I then have entered a formula that will tell me my sales per labor hour. I have attached a example in for your viewing.

SPLH HOURLY 2015.xlsx

Thank you
Rob