Custom formatting for elapsed time in minutes and seconds

Question

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

riny_van_eekelen · Answer

Warwick_Jackson_001&nbsp;Try a custom format with square bracket around the minutes portion. Like this:[mm]:ss&nbsp;

warwick_jackson_001 · Answer

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

warwick_jackson_001 · Answer

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

riny_van_eekelen · Answer

Warwick_Jackson_001&nbsp;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).&nbsp;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.

warwick_jackson_001 · Answer

Thanks Riny that make sit a bit clearer.

Forum Discussion

Custom formatting for elapsed time in minutes and seconds

5 Replies

Resources