question

TundeLevai-5563 avatar image
0 Votes"
TundeLevai-5563 asked TundeLevai-5563 answered

Complicated task

Hi everyone,

I have one spreadsheet.

I am looking for the remaining entitlement for sickness by pulling data of how many days/hours have been already used.

Could anyone help?

It is a very complex question.

H2 = Start date of the employee
I2 = Start date of the absence
J2 = End date of the absence
L2 = days/hours of the absence, but there are multiply lines of sickness (e.g. 1 employee can have 3 lines so they are in L2,L3 and L4)

There is no cell for the total used - I think I need that

R2 = month in service as employees have different entitlement, depends on how many month they are working with us.
S2 = Sickness allowance in days
T2 = Sickness allowance in hours

How do i get the remaining sickness entitlement of we have these criterias:

  • The employee's sickness allowance renewing every year from the start date

  • The first 3 days of sickness is not paid

please see table for the allowances:

204600-image.png


office-excel-itpro
image.png (38.4 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,
Are there weekends?

0 Votes 0 ·
TundeLevai-5563 avatar image
0 Votes"
TundeLevai-5563 answered emizhang-msft commented

When they are sick, weekends counts in as well, yes

Thank you for looking :)

Kind regards
Tunde

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

This is a bit complicated, do you have a basic table with header ect..?

0 Votes 0 ·
TundeLevai-5563 avatar image
0 Votes"
TundeLevai-5563 answered

Can i somehow send the excel spreadsheet to you?

On here, it doesn't let me, it says it cannot be .xlsx
When i convert it to .XML, my file is 10,000 KB

Kind regards
Tunde

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TundeLevai-5563 avatar image
0 Votes"
TundeLevai-5563 answered

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.