Excel help

tina1040

sorry. I'm not sure if this is the correct place for this.

I'm trying to set up an excel sheet to record hours rostered for 3 employees.

I would like to be able to input start and finish time along with the lunchbreak allocated for that day as lunchbreak is not paid so not included in the 36 hours worked by each employee.
Hours are Mon-fri but can start and finish time and breaks vary from day to depend due to the nature of the business.

I'm thinking 4 columns for each day (start, finish, lunch duration, hrs worked) and a total for the week so we can keep to the 36 hours.

DubCount

I guess the important information here is that Excel views the number 1 as 1 day.

If you use the 4 columns you suggested. Format the first 3 columns as time. The formula for column 4 (for row 2) would be something like:
=(A3-A2-A4)*24

Format column 4 as a number in stead of a time, and it should count the hours.

Timbo1987

Similar to above

Column A + B are time eg 08:30 for Start time in A, 17:00 for End time in B

Column C is break over 24 hours so for 1 hour = 1/24

Column D is End minus start minus break = 07:30 - =B1-A1-C1

Column E is Col D in Num format - =D1*24 = 7.5 Hours. Then multiply by hourly rate and your away