Forum Discussion
mariner84
Advocate I
Advocate ITime 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?
mariner84Advocate I
Advocate IAnonymous
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?
- mariner84
Anonymous
This is great, I'll be able to work with this. Appreciate you helping me out!