+ Reply to Thread
Results 1 to 4 of 4

Need Help on Time Sheet Formula (Day Shift OK/Night Shift=Problem)

  1. #1
    Registered User
    Join Date
    05-11-2013
    Location
    Sousse, Tunisia
    MS-Off Ver
    Excel 2007
    Posts
    6

    Need Help on Time Sheet Formula (Day Shift OK/Night Shift=Problem)

    Hello experts, I have to make a time sheet base on data given, I took the MIN entry and MAX exit for each day, I solved the problem if employee have no entry or exit to give me zero but looking further a lot of them have "entry or exit only" in a day because they work night shift and enter one day and exit on the next day.

    I am content with the resulting hours for Day Shift but Night shift is a problem that I am stuck with, I tried and researched but failed.

    I need help on function/formula that will give me hours worked by night shift.

    I attached sample table, all and any suggestion is appreciated.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-11-2013
    Location
    Sousse, Tunisia
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Need Help on Time Sheet Formula (Day Shift OK/Night Shift=Problem)

    Hello again experts, I am still stuck, any suggestion would be helpful, anything something to start with...

  3. #3
    Valued Forum Contributor Neil_'s Avatar
    Join Date
    04-19-2013
    Location
    Yorkshire
    MS-Off Ver
    Office 365 Enterprise E3 2013 / 2016
    Posts
    479

    Re: Need Help on Time Sheet Formula (Day Shift OK/Night Shift=Problem)

    Use the full date time in both the start time and end time and simply subtract one from the other. This will leave you with hours and minutes as a result instead of fractions of hours which can be confusing. You can format the cells so you can't see the date if you wish, this will not affect the result.

    Here is a great resource for working with dates and times
    http://www.cpearson.com/excel/datetime.htm
    Frob first, tweak later

  4. #4
    Registered User
    Join Date
    05-11-2013
    Location
    Sousse, Tunisia
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Need Help on Time Sheet Formula (Day Shift OK/Night Shift=Problem)

    Thank's Neil, I will check the link to get more idea, and by the way I am already doing the subtraction and fraction of hours is better my big problem is, each row is one date my formula dont lookup for exit time on the next day for night shift...

+ Reply to Thread

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