Display seconds as mm:ss with data bars

[BitFlipper]

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
--------

[Andy Pope]

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

[Bailey_Thomas]

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

[BitFlipper]

Andy, thanks that works!

Bailey, I tried that previously but it will no longer display data bars. I appreciate your suggestion though.

Thanks,
BitFlipper