Adding of times total to be in hours

[jen0dorf]

Hi thought this would be simple but .....

MY wife is paid by hour so I created a simple spread sheet:

Start time end time and hours worked using a really sophisticated =E5-C5

Ok that works

Then have a row for each day of the month

ON thebottom row I used =SUM(G2:G32) to get the total number of hours she worked and it works perfectly until the total reaches 22 hours



the total them seems to go into days hours minutes etc

I'd like the total to be in hours and minutes

Is there a way to do this?

thanks

Ian