Calculated column formula - Half days RRS feed

  • Question

  • Hi Guys,

    If I have a formula for a calculated column to calculate the number of days between two dates, how can I set it so that if somebody sets the time of one day to be 12am to 12pm ie a half day, this will appear in the column as 0.5.

    For example, a vacation request is submitted for a Thursday and Friday, but the employee wants to take half of Monday off too, so they would input the end date as Monday 12pm, but what would the formula be to make sure that sharepoint counts this as 0.5 of a day.


    Tuesday, January 8, 2019 4:09 PM

All replies

  • Hey

    For a leave approval flow, I suggest you use Date only field.

    You can directly calculate leave days through start date and end date.

    And if the start date equals end date, give the user a selection to one whole day or a half.

    Justin Liu Office Apps & Services MVP, MCSE
    Senior Software Engineer
    Please Vote and Mark as Answer if it helps you.

    Wednesday, January 9, 2019 1:20 AM