This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Good Morning All
If anyone can help with Excel problem it would be greatly appreciated.
I have a spreadsheet that has calculated the total number of tasks, the total minutes taken and the average in seconds. What i would like is it to show as minutes and seconds.
Example:
Total Number of Tasks: 12093
Total Minutes: 14363
Average Seconds: 71
I would like it to read : 1:11
Many thanks in advance for any help.
Darran
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 79%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Hi Darren,
Divide the 71 by 86400 (the number of seconds in one day) and format the result cell as a time in whatever format you like such as mm:ss
You could give it a custom number format of:
mm" min "ss" sec"
Happy to be of service! :)
Perfect, your making me look good Rory 😁 Thanks again and have a great day 🌞
Hiya Rory
Brilliant, many thanks. One last thing, i have formatted it to mm:ss and result is 01:11 but is it possible to get it to read 01 min 11 sec ? I have tried editing formula but must be doing something wrong.
But regardless, your a star 🌟