Calculate 'time of day' based on 'seconds since midnight'

[Anonymous]

Hi
Im trying to calculate the 'time of day' ([TIME]) based on a value that states 'seconds since midnight' ([SYNCTID]).
Example:

[SYNCTID] =  40847
[TIME] = ?

Doing some simple calculations on paper :-), the above should end with this:

11:20:47

any formula for this?

[judspud · Accepted solution]

Hi @Anonymous 

Please see the following link;

https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486

You will need to aggregate first to get to HH:MM:SS

Thanks,

George

[Anonymous]

Hi @judspud 

Thanks !! - much appreciated! 
It works perfectly.