• Calculate hours and Minutes

    Author
    Topic
    #461189

    Hi!

    Trying to enter a formula or format in which I can calculate the hours and minutes in which to do a task.

    For example, I want a spreadsheet that calculates how much time it should take to clean several rooms. So if we plan on 29 minutes per room and we have 5 rooms, it calculates to 2.42 instead of 2 hours and 25 minutes.

    How do I get it to show 2 hours and 25 minutes?

    Thanks!

    Viewing 1 reply thread
    Author
    Replies
    • #1168994

      The easiest solution is to enter the time per room as 0:29. Multiplying by 5 will then result in 2:25.

    • #1169005

      Hi!

      Trying to enter a formula or format in which I can calculate the hours and minutes in which to do a task.

      For example, I want a spreadsheet that calculates how much time it should take to clean several rooms. So if we plan on 29 minutes per room and we have 5 rooms, it calculates to 2.42 instead of 2 hours and 25 minutes.

      How do I get it to show 2 hours and 25 minutes?

      Thanks!

      Users may not always remember to enter the content as minutes.
      Alternatively, you can built this in the formula which show the end result.

      perhap this in C2 with Time formatting

      =(A2/1440)*B2

      A2 = 29
      B2 = 5

      • #1169025

        Users may not always remember to enter the content as minutes.
        Alternatively, you can built this in the formula which show the end result.

        perhap this in C2 with Time formatting

        =(A2/1440)*B2

        A2 = 29
        B2 = 5

        And of course, converting 08:10 to decimal hours can be as simple as multiplying the cell by 24
        =A1*24
        where A1 contains 08:10 = 8.2

    Viewing 1 reply thread
    Reply To: Calculate hours and Minutes

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: