Totalling hours in hh:mm format

Hi all,

I am trying to total the hours each staff member has worked in a week.

The hours for each day are in cells formatted in custom hh:mm. When I calculate the weekly total I get the result in time format. So if a staff member has worked 25 hours the cell returns 01:00. I'm assuming I need to be using a different cell format just not sure which one.

Thanks in advance,

Luke

format cell [hh]:mm