If the difference between the two time values (in A2 and B2) is negative, then the formula concatenates a text value consisting of the minus sign and the absolute value of the difference between the times. If you prefer to not change the dating system used in the workbook (perhaps it may mess up some other date formulas you have in the worksheet), then the only thing you can do is to create a text-based version of the time differential using a formula such as the following: The Use 1904 Date System check box controls which dating system is used, just as in earlier versions of Excel.The Advanced options of the Excel Options dialog box. Scroll through the options until you see the section called When Calculating This Workbook.Click Advanced at the left side of the dialog box.In Excel 2010 or a later version, display the File tab of the ribbon and then click Options.) (In Excel 2007 click the Office button and then click Excel Options. To change the date system, follow these steps: If you want to subtract the minutes from time, please use below formula MOD (Starttime-TIME (0,minutes,0),1) For example, there is a time in cell B12, and the number of minutes you want to subtract is displayed in cell C13, please use below formula: MOD (B12-TIME (0,20,0),1) Or MOD (B13-TIME (0,C12,0),1) Press Enter key then the result is shown.
#EXCEL MINUS MINUTES FOR MAC#
If, instead, you change to the 1904 date system (which is the default for Mac versions of Excel) then you'll see the correct negative elapsed time in your formula.
This may sound goofy, but if you use a 1900 date system (which is the default for Windows versions of Excel), then you get the # in the cell. The easiest way to solve this problem is to just change the date system used by the workbook. Mike is wondering how he can display the negative time difference properly? If he subtracts 6:33 from 6:21 he noticed that he doesn't get a negative elapsed time, as in -:12. Mike has a worksheet that contains some times.
0 kommentar(er)
