Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hiya
I have a bar chart, which is showing time values....
i want to sort from largest time to shortest time ...however when i sort numerically, this function does not work
this could be because i am converting figures e.g 37.5 to time 37.30.00
is there a sort expression that can be used to help with this issue?
Kind Regards
Joeybird
Maybe you can change that:
div(Sum([Department]), 1) & ':' & div(((Sum([Department]) - div(Sum([Department]), 1)) *60),1)
to this:
=Interval(Sum([Department])/24, 'hh:mm:ss')
Just to comment, time has a limit of 24 hours, Interval doesn't have that limit.
Hi Joanna, if 37.30.00 is a string it won't sort right.
You can use Interval to keep as number:
=Interval(37.5/24, 'hh.mm.ss') //Divided for the number of hours in a day
problem i got is i am converting the figure
time has been entered as e.g 37.5, which i have to convert to time.
as e.g
div(Sum([Department]), 1) & ':' & div(((Sum([Department]) - div(Sum([Department]), 1)) *60),1)
is there a way to format it?
Kind Regards
joeybird
Maybe you can change that:
div(Sum([Department]), 1) & ':' & div(((Sum([Department]) - div(Sum([Department]), 1)) *60),1)
to this:
=Interval(Sum([Department])/24, 'hh:mm:ss')
Just to comment, time has a limit of 24 hours, Interval doesn't have that limit.
Hiya
this calculation does work
=Interval(Sum([Department])/24, 'hh:mm:ss')
...however it still wont let me sort numerically, so I can show bar chart, highest to lowest values.
please help
Kind Regards
Hiya
sorted , just moved the sorting order around and it worked x
it still however needed your format of calculation to work
=Interval(Sum([Department])/24, 'hh:mm:ss'),
Kind Regards
Joeybird