Forum Discussion
Re: Custom formatting for elapsed time in minutes and seconds
3 Replies
- 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.
