Hours and minutes (separate cells)

[vanish]

Hi
Im working on a company timesheet, and I'm trying to add hours and minutes together. That's fine except that the hours are in a seperate cell to the minutes.
i.e
hours(hh) are R7-R27
minutes (mm) are S7-S27

now I know how to do the sum if everything is in the same cell but having things seperate is a real pain.
So anyway I need to add the total minutes at the bottom of S27 to the hours at the bottom of R27 (and the minutes should not exceed 59)

Thanks in anticipation.

[daddylonglegs]

By hh and mm do you mean that the cells are formatted that way? If they are you can just add everything together

=SUM(R7:R27,S7:S27)

then format result cell as [h]:mm

....or if your cells have just numbers

=(SUM(R7:R27)+SUM(S7:S27)/60)/24

format as before

[vanish]

Will that give me total hours in a separate cell to the minutes, as they have total hours in cell R28 and total minutes in cell S28.
I know this sounds a bit awkward, but I think they designed the timesheet to be printed & written on. Hence the hours in one column and mins in another.

[vanish]

Hi I tried what you sugested above. To make things much more straight forward to explain, I have attached a copy of the timesheet.
It is the total hours and total over time hours that i wish to ad correctly, anyway it's clear what I mean when you look at the spreadsheet

[daddylonglegs]

OK try this formula form R28

=SUM(R7:R27)+INT(SUM(S7:S27)/60)

and this one in S28

=MOD(SUM(S7:S27),60)

[vanish]

you're spot on daddylonglegs.
Thank you very much