1 of 1 people found this helpful
Not sure what the end goal is, but here is one solution
1. Right click on your Date Field in the Dimensions Pane.
Go to Default Properties and Click Date Format
Go to Custom and enter
HH:mm:ss am/pm if it is 12 Hour Format
hh:mm:ss is it is 24 Hour Format
Put your Date Field on the Row or Column Shelf and Change it to Seconds (Since that is the lowest time you wish to show)
Change it to Discrete if you want to see the actual times
Hope this helps.
You can also refer here, if you want to convert HH:MM:SS to just seconds.
DATEPART('hour',[Time DateTime]) * 3600 + DATEPART('minute',[Time DateTime])*60 + DATEPART('second',[Time DateTime])
Thank you !