Forum Discussion
Solved
Convert seconds to HH:MM:SS then SUM
Hi All, Having loads of trouble trying to get this to work. I have a column that has the duration a session was open in a job, i want to convert that the Time HH:MM:SS and be able to sum it b...
pls see the attachment below
ryan_mayu
Super User
Super Userpls try this
Column =
var _hour=int('Table'[sess_duration_sec]/3600)
var _min=int(('Table'[sess_duration_sec]-_hour*3600)/60)
var _sec='Table'[sess_duration_sec]-_hour*3600-_min*60
return time(_hour,_min,_sec)
you can use similar method to convert sum value.