Performing Calculations on Timestamps
Scenario: I need to calculate how much working hours time has passed between a creation date and a completion date.
Parameter Exception: Item can be submitted after hours, but obviously that time wouldn't be counted until 7am the next day.
Example timestamp: 2019-12-10T16:24:48Z
Working hours: 7am to 8pm
Working days: M-F
TurnAroundTime: 33 hours: 10 Minutes: 52 seconds OR 33:10:52
Note: This is very simple to do in Excel, but every way I have tried to do it in Domo has failed.
- 10.6K All Categories
- 13 Getting Started in the Community
- 29 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 300 Use Cases & Best Practices
- 499 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- 4 Private Company Board