+ Reply to Thread
Results 1 to 2 of 2

Calculate shift hours

  1. #1
    Registered User
    Join Date
    02-01-2017
    Location
    Lisboa
    MS-Off Ver
    2010
    Posts
    81

    Calculate shift hours

    Hello,

    I need to find the hours worked in three shifts: shift1 is from 07:00 to 15:00, shift2 is from 15:00 to 23:00 and shift3 is from 23:00 to 07:00
    I can calculate the total hours worked (subtraction of the end time from the start time) but am not able to separate out the hours worked in each shift (1, 2 and 3). Can anyone can help me?

    I decided to create an example of my workbook to better explain the result I pretend to have.

    Thank you in advanced!

    Kind regards,
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-01-2017
    Location
    Lisboa
    MS-Off Ver
    2010
    Posts
    81

    Re: Calculate shift hours

    Hello,

    I am going to close this thread because I found a solution for my problem..I atached the file with the formulas

    Kind regards
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to calculate night shift hours?
    By jane_dm7 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-04-2023, 09:52 AM
  2. Excel how to calculate number of night shift hours?
    By testeret in forum Excel General
    Replies: 2
    Last Post: 07-15-2013, 11:42 AM
  3. Calculate Shift Hours
    By patrickavh in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-02-2013, 09:27 AM
  4. Replies: 4
    Last Post: 09-21-2012, 12:58 AM
  5. [SOLVED] Need to calculate night shift hours
    By avdald in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-23-2012, 02:25 PM
  6. How to calculate hours across a specified shift..
    By IsabellaLearning in forum Excel General
    Replies: 3
    Last Post: 06-13-2010, 01:26 PM
  7. [SOLVED] How do I calculate hours worked on 3rd shift?
    By Steve in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-12-2005, 11:05 AM

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