Have you encountered a scenario where you have to perform date calculations in Excel at work?
When the date needs to be pushed back a few days or advance a few days how to do it? Actually, it is as simple as adding or subtracting our calculations.
As shown, plus 2 means push back 2 days, minus 2 means advance 2 days.
As shown in the figure, when we need to push back 1 hour or advance 1 hour, we need to add or subtract 1/24. instead of adding or subtracting 1.
Adding and subtracting 1 one time, and 1/24 the next, readers, isn't that a little dizzying? Why is this happening?
As shown in the figure, when we modify the data in date format to regular, we can find that the date is actually actually a string of integers. When the date plus or minus an integer, it actually means that the date is pushed back or delayed by a few days.
Date calculation is really just adding and subtracting integers., so the editor can do the math on the date.
With the example just given, you can see that the time is calculated by adding or subtracting 1/24. Why divide by 24?
As it turns out, this is because each day is an integer 1, and since there are 24 hours in a day, 1 needs to be divided by 24 when it is necessary to postpone or advance by 1 hour.
I.e., time is fractional in nature.
Look at the editor's analysis, do you have an in-depth understanding of the principle of Excel date calculation?
