Adding minutes and hours

[schmill]

Hello, I have been trying to add minutes and hours with no luck. I have the name of a task in "A" and how long it takes to complete the task in "B". All i want to do is to have a total of time it takes in hour and min format. I don't care if the hr/min are separated by a " . " or a " : ". With the example below I would like to have a result of 2hrs and 8mins 2.08 or 2:08. I have tried the different time formats and time formulas, all i am doing now is confusing myself.

Thanks,

A------------------- B
Get dressed ----- .10 or :10
Put on shoes----- .05 or :05
Eat --------------.35 or :35
Brush teeth ------ .03 or :03
Drive to work ---- 1.15 or 1:15

Total -------------2.08 or 2:08

 

[VoG]

Try like this

Excel Workbook
	B
1	00:10
2	00:05
3	00:35
4	00:03
5	01:15
6	02:08
Sheet2

 

[T. Valko]

Hello, I have been trying to add minutes and hours with no luck. I have the name of a task in "A" and how long it takes to complete the task in "B". All i want to do is to have a total of time it takes in hour and min format. I don't care if the hr/min are separated by a " . " or a " : ". With the example below I would like to have a result of 2hrs and 8mins 2.08 or 2:08. I have tried the different time formats and time formulas, all i am doing now is confusing myself.

Thanks,

A------------------- B
Get dressed ----- .10 or :10
Put on shoes----- .05 or :05
Eat --------------.35 or :35
Brush teeth ------ .03 or :03
Drive to work ---- 1.15 or 1:15

Total -------------2.08 or 2:08

When you enter the time values enter them in this format: h:mm

If you want to enter 10 minutes enter it as 0:10.

Then, a simple sum formula will do:

=SUM(B1:B5)

Format the sum formula cell as [h]:mm.

The brackets [ ] will keep the hours from rolling over into days.

 

[vaskov17]

under "Custom" format type "h.mm"

 

[Andrew Poulsom]

If you are using the decimal point as the separator:

=SUMPRODUCT(--SUBSTITUTE(TEXT(B1:B5,"0.00"),".",":"))

 

[schmill]

Thanks for your guys help, I added the zeros in the hours place when it was just min only and it works now. Obviously didn't now it was required.

Thanks again.

 

[T. Valko]

Thanks for your guys help, I added the zeros in the hours place when it was just min only and it works now. Obviously didn't now it was required.

Thanks again.

You're welcome. We appreciate the feedback!