Exel hours/minutes formula required

[mik1973]

Would appeciate if someone could provide help on a spreadsheet i'm trying to create. What i want to do is set up a formula which will add up figures in time value format -ie 22 hours and 45 minutes plus 22 hours 45 minutes =45 hours 30 minutes.Trying to find a way which will add up the minute column and transfer full hours into the hour column.


Cheers,

Mick

 

[BerkshireBull]

Just use the custom formatting set to [h]:mm:ss

See screenshots

 

[mik1973]

Just use the custom formatting set to [h]:mm:ss

See screenshots

Many thanks BerkshireBull--
Exactly what i wanted for my spreadsheet

Really appreciate the screenshots too!!
regards,

Mick