Hi , i have a data set where my assignment is to create a graph which shows the number of timestamps for every hour during the day.
The resolution so far is to create a column for every hour for a day(example shown)and formulas which validates whether the time is within the singular timestamp .
So far its working, but as i need to use the results for the timestamps in a Pivot as a categories NOT values for every single one, it creates problems, has any a good idea out of the box?
<tbody>
</tbody>
The resolution so far is to create a column for every hour for a day(example shown)and formulas which validates whether the time is within the singular timestamp .
So far its working, but as i need to use the results for the timestamps in a Pivot as a categories NOT values for every single one, it creates problems, has any a good idea out of the box?
Start time | End time | Time stamp 0900 | Time stamp 1000 | Time stamp 1100 |
0800 | 1600 | 1 | 1 | 1 |
1000 | 2300 | 0 | 1 | 0 |
<tbody>
</tbody>