Hi,
I have a data with three columns
1) Start date
2) End Date
3) No of Days
I want to calculate the date between end date and start date using the excel formula.
My concern is if the start date and end date is half date ie 01-01-2023 12:00:00 PM then the no of days to come as 0.5 but it is coming as 1.5 day.
Need excel formula for calculating half day
Thanks
Webmax
Bookmarks