VB time problem, VB date function calculation

The decimal part of the date variable with a value of less than 1 corresponds to the time of day from 0:00:00 to 24:00:00

Equivalent to 12:00:00

Equivalent to hours, hours are 24 minutes, so it is equivalent to 14:24:00

1 hour 60 minutes.

Let the decimal value less than 1 be a

24 * a

The integer part of the result is the hour.

The decimal part * 60

The integer part of this result is the minute.

The decimal part * 60

The integer part of this result is the second.

You'll find out if you try it yourself.

Change a or b to a number greater than 1, and you will find that in fact, the value of a or b is the number of days calculated from 0:00:00 on January 1, 1900, the decimal part is *24 hours, and the minutes and seconds are the same, if it is less than 1 day, only hours and minutes and seconds are displayed, and if it is greater than one day, only the year, month and day are displayed.

The 3rd floor is correct.

If you try it, it's 2 hours and 24 minutes, and it's 14 minutes and 24 seconds.

Use 24 hours* to get the hour, and the hour is 14

Hour 24 minutes is converted into time format 14:24:00

Using 24 hours* to get 12 hours is 12:00:00

That is, we define the data type of a b as time, and divide 1 into 24 hours.

month is the month in which the date is found, so the first result is 5

day is the day on which the date is found, so the second result is 16

So the result is 21

Month (5) of the first term + day (16) of the second term = 21

2003 Zaobi 11 22 -40 is equivalent to 2003 November 22 pushed forward 40 days, that is, October 13, 2003.

month( -40) is to find month(

So the resulting value is 10

month（##

is the month of the calculation date (2003-11 or 22-40).

This is how it works in the program. First of all. ##

It will be converted into a standard form of annihilation. And then.

Compute. Date. ##

This corresponds to 22 November 2003, which is 40 days forward, i.e. 13 October 2003.

Date obtained.

Finally, the month function is used.

calculates the month of , so the result is 10