Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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!
    Louise

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The easiest solution is to enter the time per room as 0:29. Multiplying by 5 will then result in 2:25.

  3. #3
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Ahh of course! I knew it was simple.

    Thanks so much!
    Louise

  4. #4
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='weese237' post='784503' date='14-Jul-2009 21:49']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![/quote]

    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
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  5. #5
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts
    [quote name='franciz' post='784520' date='14-Jul-2009 16:15']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[/quote]

    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

  6. #6
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Other good ideas! Thank you all very much!
    Louise

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •