none
Time calculations in Excel

    Question

  • Hello, 

    I encountered a small problem in excel, 

    I am trying to calculate minutes to, for example 00:00:00.000 <- Hour/Minute/Second/milisecond

    So i got a entry with like: 

    131,5219 - minutes 

    And need to form it to: 

    00:00:00.000

    Anybody know how to make such calculations in excel?

    Sincerely, 


    S1lly

    Wednesday, December 12, 2012 11:58 AM

Answers

  • =TEXT(A1,"hh:mm:ss.000")


    "Premature optimization is the root of all evil." - Knuth

    If I provoked thought, please click the green arrow

    If I provoked Aha! please click Propose as Answer

    We are here to learn, to share knowledge, and to earn points; all in about equal measure.

    Wednesday, December 12, 2012 12:44 PM

All replies

  • =TEXT(A1,"hh:mm:ss.000")


    "Premature optimization is the root of all evil." - Knuth

    If I provoked thought, please click the green arrow

    If I provoked Aha! please click Propose as Answer

    We are here to learn, to share knowledge, and to earn points; all in about equal measure.

    Wednesday, December 12, 2012 12:44 PM
  • Change the number-format to display as required.

    Select the cell, Ctrl-1, Number, Custom, hh:mm:ss.000

    Peter Thornton

    Wednesday, December 12, 2012 2:22 PM