I am trying to make a spreadsheet of the daily hours worked and a total of
the weekly hours but i am not having any luck, at the moment I have the
following

H3 08:33, H4 08:01, H5 07:23, H6 08:15, H7 08:15, when i type =sum(h3:h7) i
get 16:27 instead of 40:27 i would appreciate any advice

thanks