Forum Discussion
Timeline details
Hello, I am preparing a timeline for a project, and I am facing 2 problems. The first one is that while making a timetable, using the fill method --> series --> weekday, I found that Excel has re...
For 2nd part of your problem :-
If Excel is calculating a 1-day duration as 2 days, it might be due to how Excel handles time. Excel counts dates as whole numbers and time as fractions of a day. When you input a duration of 1 day, it includes both the start and end days.
Assuming your start date is in cell A1 and your end date is in cell B1, you can use the following formula to calculate the duration:
=B1-A1+1
If Excel is calculating a 1-day duration as 2 days, it might be due to how Excel handles time. Excel counts dates as whole numbers and time as fractions of a day. When you input a duration of 1 day, it includes both the start and end days.
Assuming your start date is in cell A1 and your end date is in cell B1, you can use the following formula to calculate the duration:
=B1-A1+1