Trying to setup a Rota for my Work. Help

**Sm1th** · 10-08-2014, 09:05 PM

Hey Guys/Gals

Im trying to set up a Rota using excel, I use to be able to do it but I have forgot all the Formulas

Can anyone tell me the Formulas required to do the below.

1: Add up the Hours I work per week.

2: Multiply Time by Currency to find out how much I get paid without Tax.

Plus - side note. how do I get text to fill 2 lines in one Cell.

**tuph** · 10-09-2014, 09:45 PM

1. Set up columns to Start Time, End Time and Hours Worked the uUse =SUM at the bottom of Hours Worked.
2. If your time is in cell C5 and the currency is in cell C6: =C5*C6.
3. Either format the cell to wrap text or, to force a new line, at the end of the first line of text hold down the ALT key while you hit the ENTER key.