Excel Date Time Conversion

Excel Date Time Conversion Excel has a special way to treat Date Time value but most people are not aware of that. You need to understand the meaning of the numeric values that represent Excel Date Time in order that you can freely perform Excel date time conversion to hours, minutes, days,  etc. After you understand the meaning of the numerical values, you can easily calculate Excel Date Time Difference. Also read the below post about calculate time difference Excel time difference in ho...
More

Excel DATEDIF Function to calculate date difference

This tutorial explains how to use Excel DATEDIF Function to calculate date difference (difference between two dates) in complete year, month or day Excel DATEDIF Function DATEDIF function stands for "Date Difference". It calculates the difference between two dates in complete year, month or day. Note that DATEDIF Function returns the "complete" value, for example, if the year difference between two dates is 1.99, the returned value is 1, not 2. If you want to calculate the Date Difference i...
More