Hi
I have data in that as per days on call is mention if only On call mention without number then that text consider as 1 Unit & if mention with number then that number consider as Unit i.e (On call x 2.5 here is 2.5 Units) so i want as per assignment sum of units Weekday Weekend & Bank Holiday if mention.
Bank holidays are mention in bank holiday sheet
so i want data pull specific format in attach file i mention expected data so please tell me how to do this
I have data in that as per days on call is mention if only On call mention without number then that text consider as 1 Unit & if mention with number then that number consider as Unit i.e (On call x 2.5 here is 2.5 Units) so i want as per assignment sum of units Weekday Weekend & Bank Holiday if mention.
Bank holidays are mention in bank holiday sheet
so i want data pull specific format in attach file i mention expected data so please tell me how to do this