+ Reply to Thread
Results 1 to 3 of 3

Calculate time periods before and after 7pm

  1. #1
    Registered User
    Join Date
    10-22-2011
    Location
    VIC
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question Calculate time periods before and after 7pm

    I am making a timesheet for employees which has their start time in B8 and finish time in C8. Because staff are paid a higher rate for working past 7pm I would like to know how to calculate the number of hours worked before 7pm (ie cell C9) and the number after 7pm (ie cell C10). Any suggestions greatly appreciated.

  2. #2
    Valued Forum Contributor
    Join Date
    08-23-2009
    Location
    Hampshire, UK
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    328

    Re: Calculate time periods before and after 7pm

    In C9
    =IF(C8>19/24,19/24-B8,C8-B8) for the time before 7pm

    and in C10
    =C8-B8-C9 for the time after 7pm

  3. #3
    Registered User
    Join Date
    10-22-2011
    Location
    VIC
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Calculate time periods before and after 7pm

    Thanks for that. Once I formatted C9 and C10 corrrectly (as [h]:mm ) it worked perfectly!

+ 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