2310123 - Using Lumira, how to convert seconds as a number to HH:MM:SS?

• Time field is specified in total seconds as number.
• How to covert such number to the HH:MM:SS format in SAP Lumira?

• Lumira Desktop

• Create the following formula:

Lpad(ToText(Floor({Time} / 3600), 0), 2, "0") + ":" + Lpad(ToText(Floor(Mod({Time}, 3600) / 60), 0), 2, "0") + ":" + Lpad(ToText(Floor(Mod(Mod({Time}, 3600), 60)), 0), 2, "0")

Time datetime date clock sec format , KBA , BI-LUM-DIS , Lumira Desktop/Discovery , BI-LUM-SRV , SAP Lumira Server , BI-LUM-OD , SAP Lumira Cloud , Problem