Dreevoo.com | Online Learning and Knowledge Sharing
 
Home | Programs | Microsoft Office | Microsoft Excel | Subtract time and display its negative value in Excel
Guest
Click to view your profile
Topics
Programs
Languages
Recipes
Home
Shortcuts
 
 

Subtract time and display its negative value in Excel

I will show you a nice little Microsoft Excel trick which you can use to subtract time and also display its negative time value.

 
  Author: NikMan | Version: 2010 | 8th June 2013 |  
 
 
1.
 

Open a new empty Excel document and enter two "times" each in one row.

Click the row bellow (see picture).

 
 
2.
 

In the entry field enter = ...

 
 
3.
 

... click the the cell with the lower time (see picture) ...

 
 
4.
 

... enter the - (minus) and then click the cell showing higher time (see picture).

 
 
5.
 

Confirm by pressing Enter. As a result you should now see a bunch of ####### characters and that's not really great looking result is it.

 
 
6.
 

Now click File in the menu ...

 
 
7.
 

.... and choose Options.

 
 
8.
 

In the new window click Advanced.

 
 
9.
 

Under When calculating this workbook settings enable the Use 1904 date system option (see picture).

Click OK.

 
 
10.
 

Excel should now display the negative time the right way.

 
 
 
   
  Please login to post a comment
  Click to open user profile  
herrty, 29th Nov 2023, 8:06 AM
Do you enjoy playing io games? What are your thoughts on shooting games? shell shockers is a highly popular online multiplayer first-person shooter io game that revolves around eggs. https://shell-shockers.co
 
 
  Click to open user profile  
boles9, 10th Dec 2023, 8:52 PM
Meta descriptions aren't just summaries; they're the gateway to 구글 SEO clicks and conversions.https://backlinkhigh.com
 
 
  Click to open user profile  
boles9, 26th Dec 2023, 4:07 PM
The absence of commercials on무료스포츠중계platforms enhances the viewing experience.https://hrtv24.com
 
 
  Click to open user profile  
boles9, 28th Dec 2023, 11:56 AM
오피스타 is a game-changer for locating nearby massage parlors. Highly recommended!https://www.opstar.shop
 
 
  Click to open user profile  
boles9, 28th Dec 2023, 3:27 PM
I adore 진주휴게텔! The saunas, massages, and overall experience are heavenly. It's my go-to place for unwinding and rejuvenating.https://www.hyutel.com/진주휴게텔
 
 
  Click to open user profile  
boles9, 1st Jan 2024, 3:17 PM
Updates on 누누tv improve my experience. I appreciate their commitment to enhancing user satisfaction.https://www.nunutv.org
 
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO