How To Display Negative Times and the 1904 Date System In Excel

Excel doesn’t display negative times well, so here are two ways we can address this, including using the 1904 date system. We will utilize the ABS, IF, SUMIF and TEXT functions in the process.

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.

Happy Excelling!

What can you do next?
Share this post with others that can benefit from it!
Leave a comment or reply below – let me know what you think!
Subscribe to this blog for more great tips in the future!
Check out my YouTube channel – click on the YouTube icon below!

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

No comments yet.

Leave a Reply