With 227.785720825 in A1 try:

=INT(A1/60)/24/60+MOD(A1,60)/24/60/60

--
HTH

Sandy

with @tiscali.co.uk


"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