converting mm.s format to mm:ss

		Microsoft Office Forums > Microsoft Excel > Excel
converting mm.s format to mm:ss

FAQ

Thread Tools

Display Modes

10-29-2012, 12:37 AM

Kevin@Radstock Kevin@Radstock is offline

Windows 7 32bit converting mm.s format to mm:ss

Office 2010 32bit

Office 365

Join Date: Feb 2012

Posts: 94

Kevin@Radstock is on a distinguished road

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.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:35 AM.