Display seconds as mm:ss with data bars

Hi,

Let's say I have a column like this:

--------
Elapsed Time
32
75
1204
553
--------

The values are seconds, representing how long it took for a certain operation to complete. It has no relation to Data or Time, so I cannot enter it as a specific date or time. Now if I highlight the four cells with the second values, I can choose Quick Analysis -> Data Bars. This gives me the data bars in each cell, showing the relative relationship between the values. That all works, no problem.

However, what I really want to do is display those seconds in mm:ss format, but still have the data bars. As soon as I enter the values in any sort of date/time format, Excel no longer gives me the option to show data bars.

Anyone know how to do that?


EDIT: To clarify, I want it to look like this, but still have the data bars in each cell:

--------
Elapsed Time
0:32
1:15
20:04
9:13
--------

If you calculate the values to be time they work as expected.

I'm not entirely sure if this will work but you can try to custom the format.. it will display mm:ss but I don't know if it will still show your data bars. I'd say it's worth a shot.
In the event you don't know how to custom just highlight the cells you want to format>go to format>format cells>Custom>under the word "Type:" just type in mm:ss. Excel will know what you want it to do.
If that doesn't work than I apologize, if it does then... your welcome :p
Have a good day.

Kind Regards,

Tommy Bailey