Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I am currently trying to convert values which have HH:MM:SS time values to the number of seconds.
I hope someone can point me into the right direction.
Best regards,
LMeijdam
Solved! Go to Solution.
Hi @Anonymous -
If the column has a Time datatype (preferable), you can do this:
Seconds Since Midnight = [Time Datatype]*86400
If it's text, you need to convert it to time first:
Seconds Since Midnight = TIMEVALUE([Text Datatype])*86400
Cheers!
Nathan
Hi @Anonymous -
If the column has a Time datatype (preferable), you can do this:
Seconds Since Midnight = [Time Datatype]*86400
If it's text, you need to convert it to time first:
Seconds Since Midnight = TIMEVALUE([Text Datatype])*86400
Cheers!
Nathan
Hi @Anonymous ,
Thanks this seems to work 🙂
Enjoy your weekend!
LMeijdam
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |