3681177 - How to convert Minutes to Hours or Seconds to Minutes in Story reports

This KBA provides a general approach you can consider/adapt based on your business needs to converting initial values from fields that reflect time in a particular granularity (seconds or minutes) to a higher granularity (minutes or hours).

SAP SuccessFactors HCM Suite

Considering the initial field is a measure, you may create the following calculated column replacing the highlighted fields you wish to convert:

• CONCAT( CONCAT( LEFT(TOTEXT([CC1]/60), LOCATE(TOTEXT([CC1]/60), '.', 0) - 1), ':' ), RIGHT( CONCAT('0', TOTEXT(ROUND(TONUMBER(SUBSTRING(TOTEXT([CC1]/60), LOCATE(TOTEXT([CC1]/60), '.', 0) + 1, 3)) * POWER(10, -LENGTH(SUBSTRING(TOTEXT([CC1]/60), LOCATE(TOTEXT([CC1]/60), '.', 0) + 1, 3))) * 60, 0))), 2 ) ) 

This will produce records such as (Initial Value → Converted Value):

• 72 → 1:12
• 3,300 → 55:00
• 1,124 → 18:44

Please validate the results on your end.

If you believe a solution native to the tool would be important for your business, you may raise an enhancement request as per KBA 2090228.

KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , How To