In that case you should use the following method. In the Number tab of the Format Cells dialog > click on Custom under Category and select the following format :mmĬlick OK and we have the Time difference in Proper format.Īnd if you want the Total of these Time differences, use SUM function.īut there can be times you need the Time difference in decimal hours. Select the cells containing formulas > Right-click > Format Cells… To remove the A.M from the result we have to apply proper Time Format to the corresponding cells. Along with the arithmetic operation, Excel has copied the Number Formatting from the adjacent cell and that is why the cell is displaying 9:30 A.M instead of 9.30. When 8:00 AM was subtracted from 5:30 PM, Excel returned 9:30.Īctually, there is nothing wrong with the calculation. But here is what Excel returns when I subtract In Time from Out Time. We can simply subtract In Time from Out Time. Simple Subtraction for calculating Time difference Simple Subtraction for calculating Time difference.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |