adding up hours
 

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

adding up hours
 

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

adding up hours
 

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