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.
Alex
