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
- 10.5K All Categories
- 6 Connect
- 916 Connectors
- 250 Workbench
- 460 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 188 Visualize
- 251 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive