View original (French)

Adding hundredths of seconds to the time format in excel

Solved
chaoui -  
Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   -
Hello,
how to add hundredths of a second to the time format

Configuration: Windows XP / Chrome 43.0.2357.130

3 answers

  2.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello

    custom cell format and type

    hh:mm:ss,00

    for entries:

    12:30:14,32

    best regards

    --
    To err is human, to persist is diabolical
    -1
  3. jc80 Posted messages 5063 Registration date   Status Member Last intervention   1 443
     
    Hello
    In format >> cell format >>> customize
    [hh]:mm:ss,0
    Best regards
    -1
    1. Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
       
      think about adding a second zero!
      0