Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey everyone.
I am creating a Pivot Chart, but one of my expressions is Time (e.g. 01:00, 02:00 etc)
The problem is that it will show as Numeric instead of Time. (see screenshot)
I cannot seem to change this format to Time in the chart, it works perfectly in normal list boxes.
Any help is appreciated
and for a real challenge i refer you to my other post:
Grave mark in filepath --> ' <--
The person who can help me with that one deserves bonus points!
Kind Regards.
Mike Cleven
Try below calculated dimension
Time(Time#([Till Time],'h:mm:ss'))
I tried it, but that didn't work.
However i tweaked it and made it =Time([Till Time],'h:mm:ss') and that works!
Thanks!