TIME() function - Fractions of a Second

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have a cell with custom formatting "m:ss.00" Yet when the value for the cell is "=TIME(0,5,58.57)", the result displayed is "5:58.00" Can anyone tell me why, or more importantly, how I get it to show what I want/it should which is "5:58.57"

EXTREMELY frustrating and any help would be GREATLY appreciated

Thanks!!
 
See answer in other ng

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

CC said:
Hi,

I have a cell with custom formatting "m:ss.00" Yet when the value for the
Click to expand...
cell is "=TIME(0,5,58.57)", the result displayed is "5:58.00" Can anyone
tell me why, or more importantly, how I get it to show what I want/it should
which is "5:58.57" ?
 
Why would you expect that you could use decimals in the TIME function
If that's the case =TIME(2.5,,) would return 02:30. All decimals in TIMES
are truncated
Why don't you just write 0:5:58.57 or if you need a formula

=TIME(0,5,58)+57/8640000

--

Regards,

Peo Sjoblom


CC said:
Hi,

I have a cell with custom formatting "m:ss.00" Yet when the value for the
Click to expand...
cell is "=TIME(0,5,58.57)", the result displayed is "5:58.00" Can anyone
tell me why, or more importantly, how I get it to show what I want/it should
which is "5:58.57" ?
 
Back
Top