Скачать или смотреть Display Negative Time in Excel | 2 Examples

In this video, we look at 2 examples of how to display negative time in Excel.

Excel does not display negative time correctly. Fortunately, it is not commonplace to need this, but if you do it is problematic.

There are two methods to fixing negative times. One is to change the date system in Excel, and the other is to fix them using a formula.

Download the workbook to practise - https://www.computergaga.com/_excel/f...

The timings of this video are:
00:00 - Negative time in Excel not working
01:25 - Changing to the 1904 date system
03:33 - Fixing negative times in Excel with a formula

Find more great free tutorials at;
https://www.computergaga.com

** Online Excel Courses **

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!

LinkedIn ►   / 18737946  
Instagram ►   / computergaga1  
Twitter ►   / computergaga1