Then there must be more to it than meets the eye, surely you can convert
3 minutes and 48 seconds in your head and see that it should be
228 seconds? Your data converted returns 03:47.786 formatted as
mm:ss.000
Maybe you can round to the nearest second?
=ROUND(A1/86400/TIME(,,1),0)*TIME(,,1)
where A1 holds the decimal format
format result as mm:ss or hh:mm:ss
--
Regards,
Peo Sjoblom
"bagoxc" wrote in
message ...
try this example
3:48 is exporting as 227.785720825
Thanks
Chuck
--
bagoxc
------------------------------------------------------------------------
bagoxc's Profile:
http://www.excelforum.com/member.php...o&userid=30084
View this thread: http://www.excelforum.com/showthread...hreadid=497654