Thread: Fixing time formats and converting hh:mm to mm:ss

Hi.

I am a newbie trying to figure out formatting on an Excel sheet that I have taken over from someone else who I cannot ask.

I have a worksheet with a lot of numbers that right now and would like to fix the formatting as follows:

00:12 (hh:mm) TO 00:12 (mm:ss)

00:02:10 (hh:mm:ss) TO 02:10 (mm:ss)

1 To 00:01 (mm:ss), 3 To 00:03 (mm:ss) etc.

1.22 TO 01:22 (mm:ss), 1.47 TO 01:47 (mm:ss) etc.

0,30 TO 00:30 (mm:ss), 1,55 TO 01:55 (mm:ss) etc.

Many thanks for your input!

I can see that the last three are not in Excel time format, but would need to see examples of the others to see if they comply. Can you post an example file?

Pete

Hi Pete.
Thanks for quick response.
I am posting a file with ALL the different times I have to deal with.
Some are also in amount of second (269 for example) but I have figured out how to convert them
Let me know if you need anything else.
I hope the attachment is actually attached.