Hours:minutes in excel

[APH]

Hi

I have a column containing hours and minutes- formatted customer hh:mm. How
do I add them up so that I get the total number of hours and minutes
required and not the days:hours:minutes.

Thanks
Alex

 

[Frank Kabel]

Hi
just sum the values and use the custom format
[hh]:mm
for the resulting cell

 

[Dave Palmer]

Hi Alex

You need to format the cell. Specify a 'custom' format and
set it to [h]:mm.

Hope this helps.

I am just about to add a new item, because I want to find
out if anyone knows how to display negative time.

Regards

Dave

 

[Ron Rosenfeld]

Hi

I have a column containing hours and minutes- formatted customer hh:mm. How
do I add them up so that I get the total number of hours and minutes
required and not the days:hours:minutes.

Thanks
Alex

Assuming the times are Excel recognized times, SUM the column and format the
result as [h]:mm


--ron

 

[APH]

Thanks everyone for fast response, and yes it worked (of course!)

Alex