Fractions of a Second Problem

[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!!

 

[Niek Otten]

A way around would be to add the fraction to the TIME() result. In your
case: =TIME(0,5,58)-(57/24/60/60)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

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" ?

 

[Niek Otten]

of course - should be +

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Peter Huang]

Hi,

I know that you wants to display the time as the format below.

5:58.57

I agree with Niek's suggestion, just a little fault needed to changed the
syntax as below.
=TIME(0,5,58)+(57/24/60/60/100)

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.