Forum Discussion
Solved
Time and Duration Help
Hello, I have a data set where I have duration in seconds, which I'm looking to convert to a format to show days, hours, minutes and seconds. Once converted, I'm then hoping it's possible to put the...
What if you generate these columns:
DAYS = TRUNC([Business Duration]/86400)
HRS = TRUNC(MOD([Business duration]/86400,1)*24)MIN = TRUNC(MOD(MOD([Business duration]/86400,1)*24,1)*60)SEC = TRUNC(MOD(MOD(MOD([Business duration]/86400,1)*24,1)*60,1)*60)FORMATTED = 'Page 1'[DAYS]&":"&'Page 1'[HRS]&":"&'Page 1'[MIN]&":"&'Page 1'[SEC]Does that help?
Anonymous
Thank you for responding and providing some insight into your data. It's too bad it cannot graph the data as required.
I'm in need to graph the average duration (once converted to dd:hh:mm:ss) monthly to show the trend that is occurring.
Have you had to do similar reporting over that time instead of looking at it vs day?
What if you generate these columns:
DAYS = TRUNC([Business Duration]/86400)
HRS = TRUNC(MOD([Business duration]/86400,1)*24)
MIN = TRUNC(MOD(MOD([Business duration]/86400,1)*24,1)*60)
SEC = TRUNC(MOD(MOD(MOD([Business duration]/86400,1)*24,1)*60,1)*60)
FORMATTED = 'Page 1'[DAYS]&":"&'Page 1'[HRS]&":"&'Page 1'[MIN]&":"&'Page 1'[SEC]
Does that help?