how to calculate number of days between 2 dates with time RRS feed

  • Question

  • 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

    Wednesday, November 11, 2020 4:26 AM

All replies