excel courses in london - correcting missing formulas

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses in london - CORRECTING MISSING FORMULAS

excel courses in london - CORRECTING MISSING FORMULAS

resolvedResolved · Low Priority · Version Standard

Richard has attended:
Excel Introduction course

CORRECTING MISSING FORMULAS

When using excel how can I add for example a name on a rota and then create a formula to calculate the hours that someone has worked?

RE: CORRECTING MISSING FORMULAS

Enter the name in the first cell.

in the next cell, enter the start time in the following format: 09:00 (for 9 hours, also represents 9am in the morning.)

Ensure the cell is formatted to the TIME format, using FORMAT > Cells > Number > TIME option

In the next cell, enter the finish time (13:00).

In the last cell, enter a formula like =finish time cell - start time cell
This will give you the total time worked.


 

Excel tip:

Quickly hide and unhide rows and columns

Use the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D.

Ctrl+Shift+9 unhides rows and Ctrl+Shift+0 unhides columns.

View all Excel hints and tips


Server loaded in 0.09 secs.