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

    Weekly working hours and consecutive working days calculation

    KAIHEI CHAN

      Hi,

       

      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!