=A1/24/3600 (and format as [h]:m:ss.00 if that's the format you want).
--
David Biddulph

"JeLe" wrote in message
...
Hi, I'm wondering if it is possible to convert an integer number, say
5.14,
into a time formatted second, 0:0:05.14. So far I've been trying the
TIME()
function [TIME(0,0,5.14)] but the output is 0:0:05 instead of 0:0:05.14.
It
rounds the seconds. Does anyone know a solution or workaround for this?
Thanks for any help!