Excel Date Time Conversion

Posted on January 23, 2015February 27, 2015 by Wyman W

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...

Excel DATEDIF Function to calculate date difference

Posted on December 8, 2014July 7, 2017 by Wyman W

This tutorial explains how to use Excel DATEDIF Function to calculate date difference (difference between two dates) in complete year, month or day. You may also want to read: Access Excel VBA day month year difference between two dates 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 d...