Hi
Hope someone can help.
I have been send a spreadsheet with a list of times in minutes and secs, however none of the number seem to be in a numerical format.
e.g. I am send 12:17, I have used the VALUE formula to convert it but it is returning it as 12:17:00 (hh:mm:ss)
I have tried using ="00:&A2 (cell which value is in) but that returns the same
when I want it to be 12:17(MM:SS)
Any one got any ideas on how to convert???
Hope someone can help.
I have been send a spreadsheet with a list of times in minutes and secs, however none of the number seem to be in a numerical format.
e.g. I am send 12:17, I have used the VALUE formula to convert it but it is returning it as 12:17:00 (hh:mm:ss)
I have tried using ="00:&A2 (cell which value is in) but that returns the same
when I want it to be 12:17(MM:SS)
Any one got any ideas on how to convert???