hello,
I am trying to do this in SharePoint calculated column.
I'm trying to calculate the number of days between 2 dates [Start Date] and [End Date], given 2 dates with time.
I have come across many examples that will calculate the days 90% of the time correctly but it doesnt do half days.
I of course also want to exclude the weekends. and holidays which i have in another list (Something to keep in mind is of course the Year and the Province, different holidays for different provinces)
here are my scenarios:
- 4 hrs is considered half day (0.5 days), anything more then 4 hrs is considered a full day (rounding up). Below should only be 0.5 days
Start Date: 11/17/2020 8am
End Date: 11/17/2020 12pm
- User enter 3.5 days for example, below should be 3.5 days
Start Date: 11/24/2020 8am
End Date: 11/27/2020 12pm
i would really appreciate anyone's help
thank you
RP
I am trying to do this in SharePoint calculated column.
I'm trying to calculate the number of days between 2 dates [Start Date] and [End Date], given 2 dates with time.
I have come across many examples that will calculate the days 90% of the time correctly but it doesnt do half days.
I of course also want to exclude the weekends. and holidays which i have in another list (Something to keep in mind is of course the Year and the Province, different holidays for different provinces)
here are my scenarios:
- 4 hrs is considered half day (0.5 days), anything more then 4 hrs is considered a full day (rounding up). Below should only be 0.5 days
Start Date: 11/17/2020 8am
End Date: 11/17/2020 12pm
- User enter 3.5 days for example, below should be 3.5 days
Start Date: 11/24/2020 8am
End Date: 11/27/2020 12pm
i would really appreciate anyone's help
thank you
RP