HOW EXCEL CALCULATE DATE AND TIME

Do you know how excel understand date and time system..........

It is very easy and simple process.
By default excel use the 1900 date system. excel does not calculate any date before the 1900 date system. okay now what is the process. Excel count the date difference from 1st Jan 1900. That means 1st Jan 1900 is the first day according to excel and 2nd Jan 1900 is the 2nd day and so on.

Example:- Let if you entered 7th nov 1983 then the serial value of date will be 30627

Now you can use the datedif function in excel to calculate the differences between two day.

So I hope now you understand that how excel understand the date. In which process excel understand date the process is called serial value of date.

Now you must be want to know how excel understand the value of time.
So it is also simple. Excel understand time as decimal fractions. That means 24:00 or 12:00 AM excel assumed that time as whole number 1.
Example if the time is 18:00 then its value is 0.75.
if the time is 15:00 then its value is 0.625

So now you understand how excel see date and time.
Here we see some example:

If Date and time is 7th Nov 2009 and the time is 20:30 then the serial value is 40124.85417


So my dear friends now tell me if the date and time is 7th Nov 2009 and the time is 24:00 what is the serial value in excel.
If you have any question or comments please send it to me..............

Have a good day friend.