Formula to convert milliseconds into minutes

**crashedinexcel** · 06-16-2007, 01:53 AM

Long time listener first time poster...

I'm getting frustrated trying to convert the a number eg. 1213391 which I know represents 20 minutes and 13.3 seconds in one easy formula. Can anyone help me out?

Thanks
Crash

**mikerickson** · 06-16-2007, 02:49 AM

Please Login or Register  to view this content.

**solnajeff** · 06-16-2007, 12:54 PM

If you want to have the numbers discrete then possibly something like

Please Login or Register  to view this content.

This would give you both minutes and seconds separately

Regards

Jeff

**oldchippy** · 06-16-2007, 01:42 PM

Just expanding on solnajeff suggestion, may be this?

=TIMEVALUE("00:"&INT(A1/60000)&":"&MOD(A1/1000,60))

**crashedinexcel** · 06-17-2007, 06:49 AM

Thanks guys, thats stopped a lot of swearing! Keep up the great work!

**Teethless mama** · 06-17-2007, 11:35 AM

Originally Posted by crashedinexcel

Long time listener first time poster...

I'm getting frustrated trying to convert the a number eg. 1213391 which I know represents 20 minutes and 13.3 seconds in one easy formula. Can anyone help me out?

Thanks
Crash

=A1/86400000

Format cell as mm:ss.0