Therefore, to subtract time in Excel: Type the start time and the end time into your spreadsheet Sutract the start time from the end time Format the result as a time.

You can subtract cells in Excel simply by putting a minus sign (-) between the cells you want to subtract in the formula bar. Now lets explore the different usages for the minus sign in Excel and see the beauty in this simplicity. I tried it on several new/different spreadsheets but it keeps happening. As times are stored as simple decimal values, you can subtract time in Excel in the same way that you can subtract any other numbers. The basic formula for subtracting two values in Excel is: value1-value2. Re: How to subtract the two different sheets in the excel. I ran a scan for viruses and none were found. Has anyone ever seen this before? I have no idea what is going on. It is like the act of putting the cursor in the formula activates it to work properly but until it is activated that C cell shows the value of the cell which it was dragged down from.

When I click on the Column C cells and then it shows the formula up top in the formula bar and if I put my cursor anywhere in the formula bar and hit Return the formula does not change however the correct value then appears in the Column C cell. For instance, the formula in C2 is =A2/B2 however the value of that cell showed 542 which was not the correct math/value.īut it gets even more weird. And when I went to check to see if the formula was correctly dragged it was.

It takes both dates (from cell B2 and A2), and subtracts them to compute the number of days in between, i.e. So I dragged that formula down and it showed 542 in all column C cells which is not correct. The formula has a straightforward process. The math was correct it showed 542 in the C1 cell. then in column C, I made the formula C1=A1/B1.

I typed in values for column A rows 1 through 10 then values for column B rows 1 through 10.

Subtraction formula in excel