Custom formatting for elapsed time in minutes and seconds

[Warwick_Jackson_001]

I am trying to format times as minutes and seconds (5:04) to get differences in elapsed time.

I have tried mm:ss but it just reverts to date and hour. How can I format for minutes and seconds

[#2]

@Warwick_Jackson_001 Try a custom format with square bracket around the minutes portion. Like this:

[mm]:ss

[#3]

@Riny_van_Eekelen 

I have put in as a custom format {mm}:ss. When I enter 5:03 it comes up as 

{03}:00

[#4]

OOOps tried [mm]:ss. 5:03 appears as 303:00 or 5:03:00 a.m.

[#5]

@Warwick_Jackson_001 When entering entering data in time format you need to be aware that Excel expects hh:mm:ss. Thus ,when you enter 5:03 it is seen as clock time 3 minutes past 5. Formatting it like elapsed time / duration this become 303 minutes (5 x 60 + 3).

5:03 will indeed appear as 5:03 am when that is you local time format and you have NOT formatted it to be an elapsed time.

[#6]

Thanks Riny that make sit a bit clearer.