Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel help

  • 02-05-2017 12:12pm
    #1
    tina1040
    Registered Users, Registered Users 2 Posts: 479 ✭✭


    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.


Comments

  • #2
    DubCount
    Registered Users, Registered Users 2 Posts: 1,094 ✭✭✭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.


  • #3
    Timbo1987
    Registered Users, Registered Users 2 Posts: 52 ✭✭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


Advertisement