'How to convert Unix date time into seconds in Power Query
If i have a column like this
How would i convert this into seconds?
Solution 1:[1]
- In PowerQuery change the type of the column to Date/Time
- Add a Custom Column with the formula
= ([business_duration] - #datetime(1970,1,1,0,0,0)) * 24 * 60 * 60 - Change the type of the new column to Whole Number
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Peter |