Results 1 to 9 of 9

Need Help to get a formula that calculates my total shift time pls

Threaded View

  1. #1
    Registered User
    Join Date
    02-03-2013
    Location
    maldives
    MS-Off Ver
    Excel 2007
    Posts
    14

    Need Help to get a formula that calculates my total shift time pls

    hey all,

    I need help please to find a formula that accurately calculates my total shift time. Most of my guys work a split shift. So I have a formula that works for that, but if they work past midnight that formula fails. So I tried a MODE function that works ok, but I am still missing two things how to subtract the break time form my total and then split this into two cell one showing the worked hrs and the other the overtime or if the hrs worked are less than 8 .. I have spend the last 5 hrs reading threats and I found a lot but there is always one component missing. So I appreciate any help I can get.. Thanks
    Attached Files Attached Files

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