12 Replies Latest reply on Jul 3, 2018 7:06 AM by Shinichiro Murakami

    Weekly working hours and consecutive working days calculation




      I have a situation where I have to count the weekly total working hours and maximum consecutive working days in a week based on the daily data.


      I calculated both value available. However, i have some issues on consecutive working days, how can i extract the maximum consecutive working days every week ie, Sunday.


      Additionally, since the original dataset is big, how can it easily to have the weekly data in a month for further analysis.


      I have mocked up the workbook. Thanks for help!