Second rounding in TIME() function
I think that cell format would be - [h]:mm:ss,00
Use calculation that David suggested: =A1/86400 (or =A1/24/3600).
A1 is your deffined time.
--
A.B.
"David Biddulph" rakstîja:
=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!
|