Mon 22 Jan 2007, 09:41Delegate Richard said...
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?
Mon 22 Jan 2007, 10:21Trainer Richard said...
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.
