What is the history of the 37:30 hour format in Excel? Why 37 ?

Christophe Rylewski 0 Points de réputation
2026-10-06T16:46:01.1066667+00:00

Simple but unfound on the www : What is the history of the 37:30 hour format in Excel? Why 37 ?

Microsoft 365 et Office | Excel | Pour l'éducation | Windows
0 commentaires Aucun commentaire

1 réponse

  1. Ryan-N 16,420 Points de réputation Personnel externe Microsoft Modérateur
    2026-10-06T17:08:54.4566667+00:00

    Hello Christophe,

    Welcome to the Microsoft Q&A forum.

    I will respond to you in English, based on the language you used in your question.

    A small suggestion: you might also consider posting your question in French; doing so could help it reach more people and increase your chances of receiving further support from the community.

    Based on your description, I understand that you would like to know why 37:30:55 is used as an example for the “Time” format in Excel’s “Format Cells” window.

    At this time, I have not found any official information explaining any particular historical significance of the number 37 in this format.

    It is possible that 37:30:55 is simply used as an example to illustrate a duration longer than 24 hours, rather than because the number 37 has any particular historical significance.

     I hope this information is helpful.

    If you have any questions or need further assistance, please feel free to share them in the comments on this post so I can continue to support you.

    I look forward to continuing the conversation.


    If the answer is helpful, please click "Yes" and kindly upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.  

    Cette réponse a-t-elle été utile ?

    0 commentaires Aucun commentaire

Votre réponse

Les réponses peuvent être marquées comme « Acceptées » par l’auteur de la question et « Recommandées » par les modérateurs, ce qui aide les utilisateurs à savoir que la réponse a résolu le problème de l’auteur.