Time Not Calculating Correct

[Sharid]

Hi

Not sure what I doing wrong, I am trying to calculate time in several cell to give me a total, however I keep giving me the wrong figure and I can not work it out. See example images below. The total does not add up.

Example 1

Time is in hh:mm


Example 2

In this example I have change the cell D2 to a total time of 3:30 minuets and the total is wrong again.

 

[Fluff]

Format the total cell as [h]:mm not hh:mm

 

[Sharid]

Thanks Fluff all sorted now.

 

[Fluff]

You're welcome & thanks for the feedback.