converting mm.s format to mm:ss

macropod · #1 10-28-2012, 12:27 AM

I know that's what you're assuming.

If the assumption is wrong, the OP needs something like:
=(INT(A1)+MOD(A1,1)/0.6)/1440
where the decimal time is in A1.

Kevin@Radstock · #2 10-29-2012, 12:37 AM

Hi

Is that formula not incorrect. If I input 17.25 in A1 and format cells mm:ss it returns 17:25 instead of 17:15.

Quote:

Originally Posted by macropod

I know that's what you're assuming.

If the assumption is wrong, the OP needs something like:
=(INT(A1)+MOD(A1,1)/0.6)/1440
where the decimal time is in A1.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting Scan	DanGeo	Word	1	05-22-2012 09:26 AM
Converting ACT to Outlook	tabletop	Office	1	01-26-2012 09:39 PM
Converting pdf... to Word ???	admin4ever	Word	1	05-27-2011 02:58 PM
Converting from Works	Menno Hershberger	Office	0	09-01-2010 11:33 PM
Converting from DOC files to PDF format	obenix	Word	2	04-29-2005 04:06 AM