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

SAP Knowledge Base Article - Public

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

Symptom

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

Environment

  • Lumira Desktop

Resolution

  • 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")

Keywords

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

Product

SAP Lumira, desktop edition 1.0