I too am not sure of the question, but this is how I add hours and minutes in Excel.
Enter the formula below in the hours cell,
=(SUM(G4:G14))+INT((SUM(H4:H14)/60))
Enter the formula below in the minute cell,
=MOD(SUM(H4:H14),60)
The formula set out above adds the hours in column G (hours) 4 to 14 and minutes in column H (minutes) 4 to 14. There is no problem with adding hours and minutes to whatever total you wish. I am using this system to keep a simple electronic log book and my duty hours. The cells in the formula are just the ones that I copied direct and obviously are for illustration only.
Last edited by check; 7th September 2007 at 13:21.