Microsoft Excel Tip #7

//Microsoft Excel Tip #7

 

Tip #7 –¬†Calculating Difference in Time

 

To calculate the difference between hours, use: =(End Time – Begin Time)*24

Excel Time

 

To calculate the difference between days, use: =End Date – Begin Date

Excel Days

 

To calculate the difference between work days, use: =NETWORKDAYS(Begin Date, End Date)

Excel Work Days

 

To calculate the difference between months within the same year, use: =MONTH(End Month)-MONTH(Begin Month)

Excel Month within Year

 

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)

Excel Months over Year

 

To calculate the difference between years, use: = YEAR(End Date)-YEAR(Begin Date)

Excel Years

 

 

 

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.

2017-08-02T13:58:01-04:00