Hi Excel Experts,
We have a database of attendance report, however, considering multiple in & out we require data base in desired format.
Into attached file there are 2 different worksheets i.e. 1. Available database & 2. Desired worksheet
From Available database, we are require fields in following manner in summarized way..
PERSONNUM | In | Out | Report date from | Report date To | No. of Shifts attended (in between to & from dates) | Details
(I have prepared manual workout into Desired worksheet, however, column F and G is difficult calculate manually hence, only 1 record is calculated)
For Example..
From To No. of Shifts attended (in between to & from dates)
21-Feb-2018 13-Mar-2018 19 (Calculated dates in between these two dates, those are only finding in Available database)
Please help me to resolve the issue.
Kravindra
Bookmarks