In Excel, subtract or add time values

Print Friendly, PDF & Email

If you want to add or subtract times, as in hours and minutes, in Excel, you do it in exactly the same way as you manipulate other numbers, but you must tell Excel you are working in hours and minutes by formatting the cells as hh:mm (or one of the other time formats).

To do this, select the cells you are going to use, right click, format, and choose hh:mm (or one of the other time formats).

Then, subtracting 9:02 from 16:30 will give you 7:28.

 

Be Sociable, Share!

Leave a Reply

Your email address will not be published. Required fields are marked *