In Tableau Desktop, I've got two date dimensions representing the beginning date and the end date of an event. To know the duration of an event, I do DATEDIFF('second', [begin date], [end date]).
Unfortunately, some events last less than one second so there are many zero length durations.
How can I get more precision (milliseconds would be fine)?
My data source is an Excel file.