And the negative time will be displayed correctly at once, see screenshots: Then in the Excel Options dialog box, click Advanced from the left pane, and in the right section, check Use 1904 date system under When calculating this workbook section. To open the Excel Options dialog box by clicking File > Options in Excel 2010/2013, and clicking Office Button > Excel Options in Excel 2007.Ģ. ![]() ![]() ![]() Here is an easy and quick way for you to display the negative time normally in Excel by changing the Excel's Default Date System to 1904 date system. In this case, how could you show negative time properly and normally in Excel?ĭisplay negative time properly with changing Excel's Default Date Systemĭisplay negative time properly with Formulas Some of us may suffer this problem, when you subtract a later time 12:20 from an earlier time 10:15, you will get the result as # error as following screenshots shown. How to display / show negative time properly in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |