Results 1 to 5 of 5

Problems with Formulas to calculate hours worked

Threaded View

  1. #1
    Registered User
    Join Date
    05-01-2013
    Location
    Dublim, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    6

    Problems with Formulas to calculate hours worked

    Hi All,

    I'm Trying to compile a spread sheet to simplify tracking our employees working times. Ideally I would like to only enter the Daily Start Time for each employee, Time Taken for Break, and then the Daily Finish times and allow the work sheet calculate the Total Hours worked each day less their break time, the amount of time of time worked after (the basic 10 hours) overtime worked each day and have these calculated per employee at the end of the 7 Day week.

    Currently I can get enter the start, break, and finish times and this will calculate fine, but the issue is if working less than the 10 hours I get ####. This is the same when there are no working hours entered for eg. Saturday and Sunday, all I get is #### for the overtime cell, and also it calculates 10.00 even though no start/break/finish times have been entered.

    I am also looking for the total number of basic working hours worked and the number of overtime hours worked totalled in the last 2 columns.

    Any help with this would be much appreciated. Sorry if I haven't explained it correctly, I have only very basic knowledge of Excel.
    Attached Files Attached Files
    Last edited by Declan McMonagle; 05-01-2013 at 04:42 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1