+ Reply to Thread
Results 1 to 4 of 4

Split out staff hours type to own columns

  1. #1
    Registered User
    Join Date
    01-24-2017
    Location
    Glasgow
    MS-Off Ver
    365
    Posts
    82

    Split out staff hours type to own columns

    Hiya,

    I have a spreadsheet of staff hours where Column I gives me the numeric value and Column K the type of hours (standard, regular, overtime etc). My boss would these values in their own columns.

    Can anyone advise what formula to use for this?

    I have attached an example spreadsheet.

    Thanks
    Attached Files Attached Files
    Last edited by BigErnKingpin; 08-29-2019 at 10:05 AM.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Split out staff hours type to own columns

    .
    One way :

    Paste in L2 ..
    Please Login or Register  to view this content.

    Use the same formula for the other columns, changing the "Regular" to the column heading for "Overtime", "Travel", etc.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-24-2017
    Location
    Glasgow
    MS-Off Ver
    365
    Posts
    82

    Re: Split out staff hours type to own columns

    Hi Logit,

    Yup this did the trick.

    Thank you very much

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Split out staff hours type to own columns

    .
    You are welcome.

    Glad to help.

+ 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. Count total of staff hours excluding hours for any leavers
    By FraserMc97 in forum Excel General
    Replies: 1
    Last Post: 04-05-2017, 11:44 AM
  2. [SOLVED] Formula to allocate staff to required number of hours
    By elleb in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-14-2017, 04:31 PM
  3. Automatic counting of Staff in a given range of hours and their overtime
    By pahackerz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2015, 07:12 AM
  4. If statement to track staff hours and holiday pay
    By corb691 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-20-2015, 03:16 PM
  5. Staff hours calculator minus relevant breaks
    By mjamil123 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-15-2013, 01:35 PM
  6. [SOLVED] A formula to work out hours on a staff rota
    By bigtiger1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-30-2013, 07:23 PM
  7. Calculating staff hours with 30min over/under condition
    By naylordaisy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-16-2013, 05:49 AM

Tags for this Thread

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