Forum Discussion
How do display duration properly?
I'm displaying durations in some of my charts. However, I haven't figured out how to do it in a proper way. Currently I'm using a column that represent minutes as a decimal number. Not optimal, si...
You should be able to add a claculated column to convert to a time.
A quick experiment gives me this formula to take a duration in minutes and turn it into a time (using time as the field with the minutes in):
=TIME(FLOOR([Time]/60,1),FLOOR(MOD([Time],60),1),MOD([Time],1)*60)
this will probably not work for times above 24 hours though, I'd expect them to wrap aroung to 0:00 at that point.
Anonymous, but how can I use such a value in column (bar) chart? As I can see it I can't use values of Data Type Time, I can only count such values. So even though the conversion works, I'm afraid it doesn't help me.
Greg_Deckler, I'm looking forward to that article. Please let me know where to find it once released.