Second rounding in TIME() function

[Guest]

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!

 

[David Biddulph]

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

 

[Guest]

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

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!

 

[David Biddulph]

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

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).

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!

 

[Guest]

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

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).
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!