To get an accurate solution, can you share a screenshot of how your base data looks like?
I took the liberty of assuming your dataset to be like this.
If this is the case, excel actually recognizes the format as hours:minutes and passes the same information to Tableau.
If thats the case, get your data in the below format.
Reload your data and combine the Minutes and seconds field like below
Be sure to use small m's as capital M's will be considered months.
The time can now be formatted as you like.
I didn't knew MakeTime is a function. I don't know why the make functions are not categorized under Date functions.
Ah, that changes things! I like to use this as my display:
STR(INT([Seconds]/60))+":"+RIGHT("0" + STR([Seconds]%60), 2)
This will convert the seconds to MM:SS format in a string.
Keep in mind: 11.10 is not 11:10. It's .10 of a minute, so you're really looking for 11:06.
Alternatively, if you want it to be in a datetime format:
MAKETIME(INT([Seconds]/3600), INT([Seconds]/60), [Seconds]%60) or [Seconds]/86400 (change Data Type to Date & Time for the latter)
And change Format display to Custom → nn:ss
You could take your existing seconds and simply do: [Seconds]/86400 as a calculation, so long as number of seconds do not exceed 24 hours.
Then format that calculation with right-click and then under Default Properties --> Number Format --> Custom --> mm:ss To format. Your result will not be 11:10 for 11.10 (decimal) it will be 11:06 in mm:ss.
Thanks Bryce i will save it for future work.
Thank you...if this resolves your issue, could you please close the thread by marking as correct. Thx, Don