Time Conversion Assistance

[steveh1873]

Hi there,

I am looking for help changing the format of time that is wrongfully set as 15:00:00 but should read 00:15:00.

This seems like such a simple issue but I am struggling to fix due to the complications dealing with Time formats.

Help is greatly appreciated.

Steve

 

[mikerickson]

=A1/60 will change 15:00:00 to 00:15:00

But if you want to change formatting, what is the current number format setting for the cell in question?

 

[steveh1873]

Thanks Mike,

You're a gem.

It was set to a custom "HH:MM:SS". I've set up a new column that with the formula above and set new column to MM:SS.

Thanks once again.

Regards,

Steve