Assume your times are in cells A1:A4; result would be this:
=INT(SUM(A1:A4))*24+HOUR(SUM(A1:A4))&"hrs, "&MINUTE(SUM(A1:A4))&"min"
Make sure all times are entered in time format, not straight numbers; i.e
07:00 instead of 7.
--
- K Dales


"delmac" wrote:

HI all, how to I add up numbers and convert them hours and minutes for eg
7 +7+7:40+7 =28hrs 40 mins
Thanks all
--
delmac