Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time punch data from rows to columns
I have daily time punch data for a single individual that I want to change
from rows to columns. My data is different than I have encountered before and the array I might normally use won't work here. Worksheet is formatted as follows: A - SSN B - Workday C - Time Punch number (1, 2, 3 and/or 4) D - [unrelated data] E - [unrelated data] F - Time Punch (time of day, i.e., 8:00 AM) Example: xxx-xx-xxxx 12/30/03 1 2:18 PM xxx-xx-xxxx 4 8:10 PM xxx-xx-xxxx 12/31/03 1 9:18 AM xxx-xx-xxxx 2 2:20 PM xxx-xx-xxxx 3 2:51 PM xxx-xx-xxxx 4 5:45 PM Some days have all Time Punch numbers 1 thru 4 (column C); some days only have 1 and 4, or 1 or 2 and 3, etc. Can someone help? Thank you so much! heyredone |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time punch data from rows to columns
Hi,
Show us what you want the data to look like. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "heyredone" wrote: I have daily time punch data for a single individual that I want to change from rows to columns. My data is different than I have encountered before and the array I might normally use won't work here. Worksheet is formatted as follows: A - SSN B - Workday C - Time Punch number (1, 2, 3 and/or 4) D - [unrelated data] E - [unrelated data] F - Time Punch (time of day, i.e., 8:00 AM) Example: xxx-xx-xxxx 12/30/03 1 2:18 PM xxx-xx-xxxx 4 8:10 PM xxx-xx-xxxx 12/31/03 1 9:18 AM xxx-xx-xxxx 2 2:20 PM xxx-xx-xxxx 3 2:51 PM xxx-xx-xxxx 4 5:45 PM Some days have all Time Punch numbers 1 thru 4 (column C); some days only have 1 and 4, or 1 or 2 and 3, etc. Can someone help? Thank you so much! heyredone |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time punch data from rows to columns
Shane,
Reading your response ... I realize I did not indicate how I wanted the final data to look like. My apologies. Using my example, I'd like for it to look like the following with the time data going across left to right: xxx-xx-xxxx 12/30/03 1 2:18 PM 2:18 PM 8:10 PM xxx-xx-xxxx 4 8:10 PM xxx-xx-xxxx 12/31/03 1 9:18 AM 9:18AM 2:20 PM 2:51 PM 5:45 PM xxx-xx-xxxx 2 2:20 PM xxx-xx-xxxx 3 2:51 PM xxx-xx-xxxx 4 5:45 PM Whereas column G is time punch #1, H is time punch #2, I is time punch #3, J is time punch #4. If it is not possible to display time punch #4 in column J because there is no time punch #2 &/or #3 for an individual (like example above), then I can possibly accept time punch #4 displaying in column H. Also, since the applicable Workday is not included in every cell in column B except the first time there is a time punch for a day, will that cause a problem? Do I need to fill in the Workday into each cell in column B? If so, is there an easy way to do that without copying & pasting manually? Thanks ever so much! -- heyredone "Shane Devenshire" wrote: Hi, Show us what you want the data to look like. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "heyredone" wrote: I have daily time punch data for a single individual that I want to change from rows to columns. My data is different than I have encountered before and the array I might normally use won't work here. Worksheet is formatted as follows: A - SSN B - Workday C - Time Punch number (1, 2, 3 and/or 4) D - [unrelated data] E - [unrelated data] F - Time Punch (time of day, i.e., 8:00 AM) Example: xxx-xx-xxxx 12/30/03 1 2:18 PM xxx-xx-xxxx 4 8:10 PM xxx-xx-xxxx 12/31/03 1 9:18 AM xxx-xx-xxxx 2 2:20 PM xxx-xx-xxxx 3 2:51 PM xxx-xx-xxxx 4 5:45 PM Some days have all Time Punch numbers 1 thru 4 (column C); some days only have 1 and 4, or 1 or 2 and 3, etc. Can someone help? Thank you so much! heyredone |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time punch data from rows to columns
Shane,
By the way, I am using Excel 2003 Thanks! -- heyredone "Shane Devenshire" wrote: Hi, Show us what you want the data to look like. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "heyredone" wrote: I have daily time punch data for a single individual that I want to change from rows to columns. My data is different than I have encountered before and the array I might normally use won't work here. Worksheet is formatted as follows: A - SSN B - Workday C - Time Punch number (1, 2, 3 and/or 4) D - [unrelated data] E - [unrelated data] F - Time Punch (time of day, i.e., 8:00 AM) Example: xxx-xx-xxxx 12/30/03 1 2:18 PM xxx-xx-xxxx 4 8:10 PM xxx-xx-xxxx 12/31/03 1 9:18 AM xxx-xx-xxxx 2 2:20 PM xxx-xx-xxxx 3 2:51 PM xxx-xx-xxxx 4 5:45 PM Some days have all Time Punch numbers 1 thru 4 (column C); some days only have 1 and 4, or 1 or 2 and 3, etc. Can someone help? Thank you so much! heyredone |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time punch & hours calculations | Excel Discussion (Misc queries) | |||
Locating duplicates within range of time punch data | Excel Worksheet Functions | |||
Finding duplicate time punch data | Excel Discussion (Misc queries) | |||
Finding duplicate time punch entries | Excel Discussion (Misc queries) | |||
sum and minus columns and rows at the same time | Charts and Charting in Excel |