View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JeLe JeLe is offline
external usenet poster
 
Posts: 1
Default 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!