Making use of Arithmetic functions

Modified on Mon, 9 Dec, 2024 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)

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