Tip #7 – Calculating Difference in Time
To calculate the difference between hours, use: =(End Time – Begin Time)*24
To calculate the difference between days, use: =End Date – Begin Date
To calculate the difference between work days, use: =NETWORKDAYS(Begin Date, End Date)
To calculate the difference between months within the same year, use: =MONTH(End Month)-MONTH(Begin Month)
To calculate the difference between months not within the same year, use: =(YEAR(End Month)-YEAR(Begin Month))*12+MONTH(End Month)-MONTH(Begin Month)
To calculate the difference between years, use: = YEAR(End Date)-YEAR(Begin Date)
If you would like to learn more about this or any Microsoft Dynamics product, please contact Complete Software by calling 410-740-1090 or by emailing support@completesoftware.net!
Based out of Columbia, Maryland, Complete Software Solutions (CSS) is proud to be a Microsoft Partner and Value Added Reseller (VAR) for Microsoft Dynamics GP and Microsoft Dynamics SL as well as a unique software developer providing solutions for businesses and non-profit organizations throughout the country. We offer a variety of services including Microsoft Dynamics consulting, system evaluation, business process analysis, system design, customizations, Enterprise Resource Planning (ERP) implementations and system upgrades.