Forum Discussion
Solved
Time Durations in a Visual/Column Chart
Hi, I want to be able to display time durations hh:mm:ss in a visual like a bar chart. The reason for this is we track our sales team on call times and we want to be able to track it month o...
This formula does not work for the purposes of displaying durations in a chart. It converts minutes into hundreds and hours into ten-thousands for the purposes of displaying a whole number in 00:00:00 format, but there are not 100 seconds in a minute or 100 minutes in an hour, so the representation of relative durations on a chart will be incorrect - shorter durations will appear too small and longer ones too big.