This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
So I'm sure there is an easy answer to this but I've been trying to rack my brain to figure it out. I'm doing a basic hours formula by count. However I would like to calculate this down to the day without effecting the previous months. So example: if we are in Feb 15, 2019 how can we calculate that without effecting January's Hours Worked? Is there formula that I can apply without having to update on a regular basis? I attached the workflow.
If your looking for a cumulative total of the hours worked in a specific month for each day, you can calculate it using like this
Start by calculating the start date for the month and the number of days in that month. Generate all the days for each month in your input. Then calculate the hours worked to this date using the following formula