Closed Thread
Results 1 to 3 of 3

Timesheet

  1. #1
    Registered User
    Join Date
    04-14-2018
    Location
    Bergen
    MS-Off Ver
    Excel for Mac
    Posts
    7

    Question Timesheet

    Hi
    I have a timesheet, but dont know how to calculate hours between 17:00 and 07:00
    C5 is when I start working
    D5 is when i'm done.
    G5 is the evening hours (between 17-07)
    My code in G5: =((D5>17/24)*(D5-17/24)+(D5<C5)*(D5+1-17/24)-(D5<C5)*(D5>1/24)*(D5-1/24)-(C5>17/24)*(D5-17/24))*24
    But when I work night from 21-07 it will return 18, not 10...

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Timesheet

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Ben Van Johnson

  3. #3
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Timesheet

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

    https://www.excelforum.com/excel-gen...ml#post4882763

    Thread Closed.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Timesheet
    By prchrj in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-30-2014, 06:37 PM
  2. Min/Max Timesheet Help
    By oebayo in forum Excel General
    Replies: 7
    Last Post: 01-04-2011, 12:47 AM
  3. TimeSheet
    By superwiki in forum Excel General
    Replies: 7
    Last Post: 05-27-2009, 12:22 PM
  4. Excel 2007 : Timesheet Help
    By stu_C in forum Excel General
    Replies: 1
    Last Post: 12-07-2008, 12:23 AM
  5. Timesheet
    By Martha in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-19-2008, 10:12 AM
  6. 24 hr timesheet
    By lee maroney in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-31-2006, 12:52 PM
  7. Timesheet
    By Matt in forum Excel General
    Replies: 3
    Last Post: 09-15-2005, 05:14 PM

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