# Thread: Calculate hours and Minutes

1. 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!

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

3. Ahh of course! I knew it was simple.

Thanks so much!

4. [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

5. [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. Other good ideas! Thank you all very much!

#### Posting Permissions

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