add format to =MIN formula to display as mm:ss

redspanna

Well-known Member
Joined
Jul 27, 2005
Messages
1,602
Office Version
  1. 365
Platform
  1. Windows
Hi all

I have a formula which I wish to include TEXT and a formula.

Text will be : and your lowest time will be


then add to that a formula to find lowest score on the 'Pivots data' page through column I

formula like : MIN('Pivots data'!I:I)

then add more TEXT like well done


final complete formula I have looks like


=" and your lowest time will be"&MIN('Pivots data'!I:I)&" well done"


however the results look like


and your lowest time will be 0.14354548375743 well done


how can I add a TEXT format to the formula to show the result as mm:ss ?

thanks in advance
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Perhaps
=" and your lowest time will be" & TEXT(MIN('Pivots data'!I:I), "mm:ss") & " well done"
 
Last edited:
Upvote 0
Thank you, couldn't quite figure where/how to place the "mm:ss" part

Cheers
 
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,167
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top