Hi,
I have a series of time in the following format.
Column U
<COLGROUP><COL style="WIDTH: 113pt; mso-width-source: userset; mso-width-alt: 5485" width=150><TBODY>
</TBODY>
When I am creating pivot tables and use this data it makes it incredibly hard to anaylse the data as there as so many values (There are around 10,000 entries between office hours) I'm looking to group the data into sets e.g. 09:00-09:29, 09:30-09:59, 10:00-10:29, 10:30-10:59 etc etc
Can anyone help with suggestions on how to do this please?
Thanks
Dave
I have a series of time in the following format.
Column U
Works Recorded Time |
07:26 |
08:12 |
08:21 |
08:28 |
08:29 |
08:31 |
08:40 |
08:42 |
08:43 |
08:44 |
08:46 |
08:47 |
08:48 |
08:49 |
08:50 |
08:51 |
08:52 |
08:53 |
08:54 |
08:55 |
08:56 |
08:57 |
08:58 |
08:59 |
09:00 |
09:01 |
09:02 |
09:03 |
09:04 |
09:05 |
09:06 |
09:07 |
09:08 |
09:09 |
09:10 |
09:11 |
09:12 |
09:13 |
09:14 |
09:15 |
09:16 |
09:17 |
09:18 |
09:19 |
09:20 |
09:21 |
09:22 |
<COLGROUP><COL style="WIDTH: 113pt; mso-width-source: userset; mso-width-alt: 5485" width=150><TBODY>
</TBODY>
When I am creating pivot tables and use this data it makes it incredibly hard to anaylse the data as there as so many values (There are around 10,000 entries between office hours) I'm looking to group the data into sets e.g. 09:00-09:29, 09:30-09:59, 10:00-10:29, 10:30-10:59 etc etc
Can anyone help with suggestions on how to do this please?
Thanks
Dave