easy problem for you to solve. time problems

[edwinver]

I am very new to Excel and I use it not much. But my problem is: I have to add different times to a total time.

person A worked 2:30(hh:mm) hours, person B worked 1:35 hours, person C worked 4:54 etc. Now I want to have a cell with the totall time (in this case it should be: 8:59).

Can anybody help me please.

Edwin


BTW English is not my native language so sorry if I have writen something wrong.

 

[almar_dc]

Hi Edwin, simplest way is to format the cells using custom formats as hh:mm then as long as you input the hours worked as eg 02:30 or 12:20 when you sum the cells in the normal way you should get the answer 14:50.

Regards

 

[almar_dc]

Hi Edwin, simplest way is to format the cells using custom formats as hh:mm then as long as you input the hours worked as eg 02:30 or 12:20 when you sum the cells in the normal way you should get the answer 14:50.

Regards

 

[edwinver]

On 2002-03-28 02:37, almar_dc wrote:
Hi Edwin, simplest way is to format the cells using custom formats as hh:mm then as long as you input the hours worked as eg 02:30 or 12:20 when you sum the cells in the normal way you should get the answer 14:50.

Regards

Thanks. That worked but if the total time is more than 24 hours he will start to count from zero again and I am missing 24 hours. What to do with that?

 

[Ian Mac]

Change the Format of the cell to Custom Format, and use [h]:mm or [h]:mm:ss as required

 

[edwinver]

Thanx very much. It works just fine now.