Forum Discussion
Advocate IVConverting seconds to HH:MM:SS format in visuals
I am importing an Excel spreadsheet with a column "Total Talk Time" in the format of hh:mm:ss. When I try to use the Duration Data Type, all of my values error out. Am I doing something wrong?
Prior to posting this, I did search the forums and everything I found similar is either several years old, prior to the duration data type being available, or the solutions have invalid links. In anticipation that I may not be able to just easily convert, I have already done the work to convert the data into seconds (hours*3600+minutes*60+seconds). Now though, I'm at a loss on how to get those seconds back into a hh:mm:ss format in my visuals.
Any help is greatly appreciated!!
Sample Data (last 4 columns calculated in Query Editor):
| Agent | Talk Time | Hours | Minutes | Seconds | Total Time in Seconds |
| Bill | 2:12:34 | 2 | 12 | 34 | 7954 |
| Sally | 1:54:26 | 1 | 54 | 26 | 6866 |
| Jill | 1:23:13 | 1 | 23 | 13 | 4993 |
| Bob | 2:03:01 | 2 | 3 | 1 | 7381 |
1 Reply
- Greg_Deckler
Community Champion
Not sure, an Enter Data query worked and recognized them as Duration ust fine. However you are likely to be sorely disappointed, while Power Query has a Duration data type, Power BI Desktop does not really have that in probably the way you want.
