Beast Mode Decimal number to Time Format

Stu5677 · October 2023

Is there a way to convert the current decimal number to (HH:MM:SS) format? We are using a beast mode that currently calculates minutes for us..

SUM(Talk time to decimal) / SUM(LIVE CONNECT count) = 1,167.83 / 85 = 13.74 mins.. Can i turn that into 00:13:74?

GrantSmith · October 2023

If your decimal is the number of seconds you can use the SEC_TO_TIME function or convert your minutes to seconds and then use the function

I’ve posted about formatting time differences which may be of benefit to you

ColemenWilson · October 2023

TIME_FORMAT((SUM(Talk time to decimal) / SUM(LIVE CONNECT count) ), "%H:%i:%s")

Stu5677 · October 2023

@ColemenWilson - That is leaving all columns blank. Could it be a decimal issue?

GrantSmith · October 2023

If your decimal is the number of seconds you can use the SEC_TO_TIME function or convert your minutes to seconds and then use the function

I’ve posted about formatting time differences which may be of benefit to you

Best Answer