ADDING TIME

Hi Jason,

Thank you for the forum question.

To get Excel to understand it is time, time must be typed like this 10:35:20
10 hours 35 minutes and 20 seconds

But now to the tricky part. Excel cannot add up time if the result is more than 24 hours without custom formatting. If you select the range where you want to work with more than 24 hours you will need to use the format code below.


[h]:mm;@

Select the range. On the Home tab in the Number group click on the down arrow you have in the bottom right corner of the group. On the left side of the dialog box which appear. Click custom and in the Type box type the code above. If you also want to include seconds the code is [h]:mm:ss;@



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector