Hello there,
I have a sheet (exported from the website analyser tool Matomo) which lists time spent on a certain page as numeric seconds, so for example 356 seconds. This is not intuitively understandable so I’d like to change the format to mm:ss - unfortunately I cant find a formular to do this and my own tries failed 
Can someone please help me?
Thanks
RuGru
You could enter =356/86400 (divide by number of seconds in a day) and format cell as [HH]:MM:SS. It will give hours as well in case of lingerers.
Hi there,
thanks for the quick reply.
That worked perfectly!
Have nice day!
The colon-separated formats should only be used for TOD (TimeOfDay) for which they are specified. Unevitably you need to use the day (d) as the unit of time in the background to be able to apply that formatting at all.
The author of your analyser tool did well to give durations and their totals to be displayed in a single-unit format. If the resolution is too high for your purposes you may shift to min (minutes) or to h (hours) with decimal fractions where needed…This way you get actually clear conversions instead of misleading formats.
Hi Lupp,
thanks for the clarification.
The problem is that decimal minutes are not intuitevely understandable - at least to me and my colleagues.
Best
Ru