Exel hours/minutes formula required

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

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

See screenshots

BerkshireBull said:

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

See screenshots

Click to expand...

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

Really appreciate the screenshots too!!
regards,

Mick