Maybe your time values do not include any seconds, like the example you posted
Maybe your time values do not include any seconds, like the example you posted.
Ok, I have two final questions:
1) I have used the custom format suggested ie [m]:ss
and this time 01:02:00 is converted to 62 mins (which makes sense ie 1 hour and 2 mins is 62 mins)
and this time 02/01/1900 05:03:00 is converted to 3183:00 ie 3,183 minutes, which seems odd?
2) The original raw format of the two times above come up as 0.0430555555555556 and 2.21041666666667, when pasted as values, from a CSV file.
If I then use this formula =TIME(0,MINUTE(B2)+(SECOND(B2)<>0),0) to round them up to the nearest minute (you may need to change the B2 cell reference), I get 02:00 and 03:00, which looks like 2 and 3 minutes, respectively (when the custom [m]:ss formatting is applied in those cells, as well. This seems very odd!
Do you know why 62 mins and 3,183 minutes would be rounded down to 2 and 3 mins, respectively?