sum of time

G

Guy Cohen

Hi all
I have a column with HH:nn data
I want excel to sum the values - is it possible ?
e.g.:
12:40
20:10
 
B

Bob Phillips

Just sum as usual and format the results cell as [h]:mm

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
G

Guy Cohen

Dear Bob
Thanks for the reply
I would not post the question if it was that simple.

Put 12:33 in A1, and 15:55 in A2
Try to set A3 to be the sum....

Guy

Bob Phillips said:
Just sum as usual and format the results cell as [h]:mm

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

Guy Cohen said:
Hi all
I have a column with HH:nn data
I want excel to sum the values - is it possible ?
e.g.:
12:40
20:10
-------------
32:50

TIA
Guy
Click to expand...
Click to expand...
 
B

Bob Phillips

Well I did, and it did, it really was that simple! I get 28:28.

And your original example works too.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

Guy Cohen said:
Dear Bob
Thanks for the reply
I would not post the question if it was that simple.

Put 12:33 in A1, and 15:55 in A2
Try to set A3 to be the sum....

Guy

Bob Phillips said:
Just sum as usual and format the results cell as [h]:mm

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

Guy Cohen said:
Hi all
I have a column with HH:nn data
I want excel to sum the values - is it possible ?
e.g.:
12:40
20:10
-------------
32:50

TIA
Guy
Click to expand...
Click to expand...
Click to expand...
 
G

Guy Cohen

can you please post your excel file here?
pleaseeeeeeeee?
G

Bob Phillips said:
Well I did, and it did, it really was that simple! I get 28:28.

And your original example works too.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

Guy Cohen said:
Dear Bob
Thanks for the reply
I would not post the question if it was that simple.

Put 12:33 in A1, and 15:55 in A2
Try to set A3 to be the sum....

Guy

Bob Phillips said:
Just sum as usual and format the results cell as [h]:mm

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

Hi all
I have a column with HH:nn data
I want excel to sum the values - is it possible ?
e.g.:
12:40
20:10
-------------
32:50

TIA
Guy
Click to expand...
Click to expand...
Click to expand...
 
B

Bob Phillips

I have posted it to http://cjoint.com/?lpoKS6B5Zu

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

Guy Cohen said:
can you please post your excel file here?
pleaseeeeeeeee?
G

Bob Phillips said:
Well I did, and it did, it really was that simple! I get 28:28.

And your original example works too.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

Guy Cohen said:
Dear Bob
Thanks for the reply
I would not post the question if it was that simple.

Put 12:33 in A1, and 15:55 in A2
Try to set A3 to be the sum....

Guy

Just sum as usual and format the results cell as [h]:mm

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

Hi all
I have a column with HH:nn data
I want excel to sum the values - is it possible ?
e.g.:
12:40
20:10
-------------
32:50

TIA
Guy
Click to expand...
Click to expand...
Click to expand...
 
Top