Forum Discussion
Custom formatting for elapsed time in minutes and seconds
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
Warwick_Jackson_001 Try a custom format with square bracket around the minutes portion. Like this:
[mm]:ss
- OOOps tried [mm]:ss. 5:03 appears as 303:00 or 5:03:00 a.m.
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.
- Thanks Riny that make sit a bit clearer.