Calculating hour differential over multiple days
I'm trying to calculate the number of hours elapsed between when a given event occurred and the current time. Both are formatted as "DD MMM YYYY HH:MM: SS".
Basically, if the event occurred at 01 Jan 2019 12:30:00, and the current date is 03 Jan 2019 12:00:00, I would like the output to be 47:30:00
Thanks!
Comments

Hi, @user03545,
You'll need to get a bit creative to build out the hours:minutes:seconds string. Basically, you want to calculated the number of elapsed days and conver to hours by multiplying by 24. Check out the datediff() function.
Then, you'll want to calculate the difference between the times (ignoring the dates for now) of your two timestamps. That difference between the times returns a time. Check out the timediff() and hour() functions.
You'll then want to add the two hours calculations together: hours derived from datediff() and hours derived from timediff().
Then, you can use the timediff(), minute() and second() functions to find the hours and minutes portions of the output you want.
At this point, you have the number of hours, minutes, and seconds (each as distinct numbers) between your two timestamps. The last thing to do is to concatenate those numbers together into the format you want. For that, check out the concat() function.
Hope that helps.
Best,
Dan
0
Categories
 All Categories
 1.7K Product Ideas
 1.7K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 292 Workbench
 4 Cloud Amplifier
 8 Federated
 2.8K Transform
 95 SQL DataFlows
 602 Datasets
 2.1K Magic ETL
 3.7K Visualize
 2.4K Charting
 691 Beast Mode
 43 App Studio
 39 Variables
 658 Automate
 170 Apps
 441 APIs & Domo Developer
 42 Workflows
 5 DomoAI
 32 Predict
 12 Jupyter Workspaces
 20 R & Python Tiles
 386 Distribute
 111 Domo Everywhere
 269 Scheduled Reports
 6 Software Integrations
 112 Manage
 109 Governance & Security
 8 Domo University
 30 Product Releases
 Community Forums
 39 Getting Started
 29 Community Member Introductions
 98 Community Announcements
 Domo Community Gallery
 4.8K Archive