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 Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 303 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 763 Beast Mode
- 65 App Studio
- 42 Variables
- 709 Automate
- 184 Apps
- 460 APIs & Domo Developer
- 54 Workflows
- 11 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 134 Manage
- 131 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive