Convert Seconds to Days, hours and minutes

[system]

Hello Friends,

I have a requirement where they want seconds to be converted to days, hours, minutes

Ex: 11924 seconds = 0 Days, 3 hours, 31 Minutes

I’m working on WEBI XI R2

Appreciate your help.
GJR

---

gjr (BOB member since 2005-06-09)

[system]

Do a search for “convert seconds”; there’s a bunch of existing topics.

---

joepeters (BOB member since 2002-08-29)

[system]

I think you can edit this variable … or create new variable like
seconds/60 = which will display minutes
(seconds/60)/60= will display hours
((seconds/60)/60)/24= will display hours etc.,

Again you need to be careful…in some areas seconds will display in milli seconds…i.e., 1000 milliseconds is 1 sec…

Thanks & Regards,
Suresh Gooty

---

surya.g (BOB member since 2009-11-24)

[system]

GJR,

This post can give you an idea:

Convert minutes to Weeks/Days/Hours/Minutes

Hey guys, I have a column in the SQL Server database which tells me the number of minutes between 2 dates. Could anyone tell me how to convert that to the format; 3 Years, 2 Months, 1 Week, 2 Days, 13 Hours, 52 Minutes. I get lost very quickly. Cheers, Stuart stuartgmilton (BOB member since 2003-01-30)

---

Marek Chladny (BOB member since 2003-11-27)

[system]

[quote:55da03be75=“suresh.gooty”]I think you can edit this variable … or create new variable like
seconds/60 = which will display minutes
(seconds/60)/60= will display hours
((seconds/60)/60)/24= will display hours etc.,

[/quote]

I guess this won’t give the desired result.

You need to use MOD() function also.

---

Rakesh_K (BOB member since 2007-12-11)