Morning all
I have a database full of dwell times (for drivers on site) that are in the below format. Is it possible to insert a slicer that can be changed to have options to select all entries over 4, 5 & 6hrs?
When I am inserting the slicer it is listing all entries and as you can imagine (with the hrs, minutes and seconds) there are a lot.
[TABLE="width: 95"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"]01:49:27[/TD]
[/TR]
[TR]
[TD="align: right"]00:08:03[/TD]
[/TR]
[TR]
[TD="align: right"]01:15:03[/TD]
[/TR]
[TR]
[TD="align: right"]02:11:35[/TD]
[/TR]
[TR]
[TD="align: right"]01:05:42[/TD]
[/TR]
[TR]
[TD="align: right"]02:51:52
[/TD]
[/TR]
</tbody>[/TABLE]
Hope this makes sense
Thanks
I have a database full of dwell times (for drivers on site) that are in the below format. Is it possible to insert a slicer that can be changed to have options to select all entries over 4, 5 & 6hrs?
When I am inserting the slicer it is listing all entries and as you can imagine (with the hrs, minutes and seconds) there are a lot.
[TABLE="width: 95"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"]01:49:27[/TD]
[/TR]
[TR]
[TD="align: right"]00:08:03[/TD]
[/TR]
[TR]
[TD="align: right"]01:15:03[/TD]
[/TR]
[TR]
[TD="align: right"]02:11:35[/TD]
[/TR]
[TR]
[TD="align: right"]01:05:42[/TD]
[/TR]
[TR]
[TD="align: right"]02:51:52
[/TD]
[/TR]
</tbody>[/TABLE]
Hope this makes sense
Thanks