Second rounding in TIME() function
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! |
Second rounding in TIME() function
=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! |
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! |
Second rounding in TIME() function
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! |
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! |
All times are GMT +1. The time now is 06:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com