+ Reply to Thread
Results 1 to 2 of 2

Time punch record reformatting - vertical into horizontal + bonus weeks worked

Hybrid View

  1. #1
    Registered User
    Join Date
    04-09-2024
    Location
    Long Beach, California
    MS-Off Ver
    MS 365
    Posts
    6

    Time punch record reformatting - vertical into horizontal + bonus weeks worked

    Hello! I'm looking for some help with some sort of formula or way to quickly automate the following:

    I have a long list of time records for an employee that I'd like in a different format. Currently they're like the left side of below, when I'd like them to look like the right (single row per date worked).

    This seems straightforward enough with some sort of vstack or hstack shenanigans, but I don't fully understand those yet. As a bonus, if we could then figure out how many weeks a person worked from the dates on the right range, that would be great too.
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,909

    Re: Time punch record reformatting - vertical into horizontal + bonus weeks worked

    Hi, have you tried using a pivot table?
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ 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. Sum vertical and horizontal - time tracking by User
    By csimo in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-16-2021, 11:54 AM
  2. Sum hours worked between time frame based on punch times and criteria
    By spacej3di in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-15-2020, 04:29 PM
  3. [SOLVED] reformatting table from horizontal to vertical
    By melody10 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-30-2017, 01:20 AM
  4. Replies: 0
    Last Post: 05-14-2012, 05:36 PM
  5. Replies: 2
    Last Post: 10-24-2011, 04:49 PM
  6. Convert multiple x rows for a record to single - vertical to horizontal data
    By DinLA in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-21-2011, 11:47 PM
  7. [SOLVED] freeze horizontal and vertical panes at the same time in Excel
    By Bridgette in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-08-2005, 10:05 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