Making use of Arithmetic functions

Modified on Mon, 9 Dec at 11:41 AM

1. Convert No. of Seconds to hours format (HH:MM:SS)

Description:

Convert the time given in seconds to hour format (HH:MM:SS).

Example:

Time in seconds	Time in Hours
4500	1:15:0
3254	0:54:14
4253	1:10:53
2546	0:42:26

UDDC Expression:

round(floor((Seconds/3600)),0)
+ " : " +
round(floor(mod(Seconds,3600)/60),0)
+ " :" +
round(floor(mod(floor(mod(Seconds,3600)),60)),0)

crosstab Tabular Geomap Graphs Smarten View Visualization Expression formula UDDC Arithmetic Functions Seconds Hours Business Intelligence Support Business Intelligence Articles Business Intelligence Training