On Fri, 3 Feb 2006 04:44:10 -0800, 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

If they are all entered as time:

7:00
7:00
7:40
7:00

Then just SUM the range and format the result cell as [h]:mm

(Format/Cells/Number Custom Type: [h]:mm)

Note the brackets around the h -- this will keep the hours from "rolling over"
every 24.


--ron