How to change decimals to Time Format(AHT)
Hi Team,
I am trying to convert decimals to time format(as AHT - Average Handling Time), but unlucky used different way of calculating in beastmode but I am not able to get the output. Please refer the image 1 and provide me how can i get this sorted out.
Handle Time shows as: 0.00825231481481481
Handle Contacts: 1
I need to divide = Sum(Handle Time)/Sum(Handle Contacts) = Convert the result to Time Format
Regards
Kiruba
Comments
-
A BeastMode calculation can allow you to convert your decimal (number of days I'm assuming here) to an HH:MM:SS format:
CONCAT(ROUND(Sum(`Handle Time`)/Sum(`Handle Contacts`) * 24 - 0.5, 0), ':', ROUND((Sum(`Handle Time`)/Sum(`Handle Contacts`)*24 - ROUND(Sum(`Handle Time`)/Sum(`Handle Contacts`) * 24 - 0.5))*60-0.5, 0), ':', ROUND(((Sum(`Handle Time`)/Sum(`Handle Contacts`)*24 - ROUND(Sum(`Handle Time`)/Sum(`Handle Contacts`) * 24 - 0.5))*60 - ROUND((Sum(`Handle Time`)/Sum(`Handle Contacts`)*24 - ROUND(Sum(`Handle Time`)/Sum(`Handle Contacts`) * 24 - 0.5))*60 - 0.5, 0))*60, 0))
We're simply calculating the number of hours, then subtracting the number of hours to get the remained and multiplying it by 60 to then get the minutes and taking that value and multiplying it by an additional 60 to get the number of seconds.
With this formula it'll convert any number > 1 day to the number of hours.
For example 2.00825231481481481 would convert to 48:11:53
**Was this post helpful? Click the heart icon**
**Did this solve your problem? Accept it as a solution!**0
Categories
- 10.6K All Categories
- APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 338 Workbench
- 250 Domo Best Practices
- 11 Domo Certification
- 460 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 62 Kowaza
- 295 仲間に相談
- 649 ひらめき共有