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
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 667 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 146 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive