Minutes to Seconds
 

Example;
Cell reads 114.4
Need to convert to 74.4 Seconds.
Any thoughts?

Minutes to Seconds
 

With
A1: 114.4

If I understand correctly....try this:
B1: =INT(A1/100)*60+MOD(A1,100)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"M.A.Tyler" wrote:

Example;
Cell reads 114.4
Need to convert to 74.4 Seconds.
Any thoughts?

Minutes to Seconds
 

If the A1 had been entered as 1:14.4, you could use =A1*24*3600 (and format
as number or general).
--
David Biddulph

"Ron Coderre" wrote in message
...
With
A1: 114.4

If I understand correctly....try this:
B1: =INT(A1/100)*60+MOD(A1,100)

"M.A.Tyler" wrote:

Example;
Cell reads 114.4
Need to convert to 74.4 Seconds.
Any thoughts?