Forum home » Delegate support and help forum » Microsoft Excel Training and help » Adding hours

Adding hours

ResolvedVersion 365

Wed 21 Sep 2022, 15:31 Delegate Olivier said...

Olivier has attended:
Excel Introduction course

Adding hours

How to have a total weekly hours on a rota system
If someone does 10.00 to 6 pm 5 days a week, I need to know the total of hours for that week. On excel that is

Wed 21 Sep 2022, 16:42 Trainer Jens said...

RE: Adding hours

Hi Olivier,

Thank you for the forum question.

Please have a look at the link below.

https://support.microsoft.com/en-us/office/add-or-subtract-time-16aa6697-6d6e-49c1-8e2c-3398a7cad6ad

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

Tue 27 Sep 2022: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Colouring cells containing formulas

Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

View all Excel hints and tips

Adding hours

Adding hours

RE: Adding hours

Excel articles

Excel tip:

Colouring cells containing formulas