Second rounding in TIME() function
I'm agree!
--
A.B.
"David Biddulph" rakstîja:
It would be [h]:mm:ss,00 instead of [h]:mm:ss.00 if the OP had a comma as
his decimal separator, but he showed the example as 0:0:05.14, not as
0:0:05,14
It would be [h]:mm:ss.00 instead of [h]:m:ss.00 if the OP always wanted two
digits for the number of minutes, but he showed the example as 0:0:05.14,
not as 0:00:05.14 (which is why I said "... if that's the format you want").
--
David Biddulph
"Aivis" wrote in message
...
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.
"David Biddulph" rakstîja:
=A1/24/3600 (and format as [h]:m:ss.00 if that's the format you want).
"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!
|