Forum Discussion

tonylort's avatar
tonylort
Copper Contributor
Oct 31, 2024

How can I enter minutes and seconds without it being converted to a time.?

I want to enter actual number of minutes and seconds and not have it converted to a time.  I will be entering actual durations of actions and need to be able to work with those.

  • tonylort 

    Excel does not distinguish between time and duration.

    Type 0:43:14 for 43 minutes and 14 seconds.

     

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    tonylort 

    Excel does not distinguish between time and duration.

    Type 0:43:14 for 43 minutes and 14 seconds.

     

Resources