Sum of total time in arange of cells

[Guest]

Hope everyone having a nice day.

I've number of cells with total time (i.e. 4hrs and 30 min
as 4:30 and so on). I want to add all of these times to
have a total hour and minutes. For the minutes, formula
should consider an hour for every 60 min. Such as, if I
have 4:30 and 8:45 in two different cells, sum of these
cells should be 13:15.

Hope it makes sense.
Thanks,

 

[Frank Kabel]

Hi
just add your time values. e.g.
=A1+A2
where A1 = 04:30; A2 = 08:45
you may format the target cell with the custom format [hh]:mm if your
sum can exceed 24 hours

Frank

 

[Guest]

Arrive
8:00 16:00 8:00
10:15 17:30 7:15
10:15 16:00 5:45
10:00 17:00 7:00
15:30 20:15 4:45
7:00 16:45 9:45
0:00
13:00 19:15 6:15
7:15 14:45 7:30
56.15

-----Original Message-----
Hi
just add your time values. e.g.
=A1+A2
where A1 = 04:30; A2 = 08:45
you may format the target cell with the custom format [hh]:mm if your
sum can exceed 24 hours

Frank

Hope everyone having a nice day.

I've number of cells with total time (i.e. 4hrs and 30 min
as 4:30 and so on). I want to add all of these times to
have a total hour and minutes. For the minutes, formula
should consider an hour for every 60 min. Such as, if I
have 4:30 and 8:45 in two different cells, sum of these
cells should be 13:15.

Hope it makes sense.
Thanks,

.

 

[Guest]

Sorry for the previous message.
This is what I have. And when custoemr format the cell as
[hh]:mm: ss I get 1347:33:00 and not 56:15.

Arrive
8:00 16:00 8:00
10:15 17:30 7:15
10:15 16:00 5:45
10:00 17:00 7:00
15:30 20:15 4:45
7:00 16:45 9:45
0:00
13:00 19:15 6:15
7:15 14:45 7:30
56.15

-----Original Message-----
Hi
just add your time values. e.g.
=A1+A2
where A1 = 04:30; A2 = 08:45
you may format the target cell with the custom format [hh]:mm if your
sum can exceed 24 hours

Frank

Hope everyone having a nice day.

I've number of cells with total time (i.e. 4hrs and 30 min
as 4:30 and so on). I want to add all of these times to
have a total hour and minutes. For the minutes, formula
should consider an hour for every 60 min. Such as, if I
have 4:30 and 8:45 in two different cells, sum of these
cells should be 13:15.

Hope it makes sense.
Thanks,

.

 

[Frank Kabel]

Hi
if all the cells are formated as times (no toher custom format) and
you're summing these cells, using the custom format [hh]:mm, should
return 56:15
Any chance there are some numers within, etc.

Frank

Sorry for the previous message.
This is what I have. And when custoemr format the cell as
[hh]:mm: ss I get 1347:33:00 and not 56:15.

Arrive
8:00 16:00 8:00
10:15 17:30 7:15
10:15 16:00 5:45
10:00 17:00 7:00
15:30 20:15 4:45
7:00 16:45 9:45
0:00
13:00 19:15 6:15
7:15 14:45 7:30
56.15

-----Original Message-----
Hi
just add your time values. e.g.
=A1+A2
where A1 = 04:30; A2 = 08:45
you may format the target cell with the custom format [hh]:mm if your
sum can exceed 24 hours

Frank

Hope everyone having a nice day.

I've number of cells with total time (i.e. 4hrs and 30 min
as 4:30 and so on). I want to add all of these times to
have a total hour and minutes. For the minutes, formula
should consider an hour for every 60 min. Such as, if I
have 4:30 and 8:45 in two different cells, sum of these
cells should be 13:15.

Hope it makes sense.
Thanks,

.

 

[Guest]

Frank,

Many thanks for your patience and quick answer. My cells
are formated for time. But when I try to custom format the
sum cell, I get an option of [hh]:mm:ss and not [hh]:mm as
you recomended below.

How do I change the format to what you recomend? I think
that will solve the problem.

Thanks again.

Hoque

-----Original Message-----
Hi
if all the cells are formated as times (no toher custom format) and
you're summing these cells, using the custom format [hh]:mm, should
return 56:15
Any chance there are some numers within, etc.

Frank

Sorry for the previous message.
This is what I have. And when custoemr format the cell as
[hh]:mm: ss I get 1347:33:00 and not 56:15.

Arrive
8:00 16:00 8:00
10:15 17:30 7:15
10:15 16:00 5:45
10:00 17:00 7:00
15:30 20:15 4:45
7:00 16:45 9:45
0:00
13:00 19:15 6:15
7:15 14:45 7:30
56.15

-----Original Message-----
Hi
just add your time values. e.g.
=A1+A2
where A1 = 04:30; A2 = 08:45
you may format the target cell with the custom format

[hh]:mm if
your

.

 

[Frank Kabel]

Hi
Just choose the custome category and type this format code manually

Frank

Frank,

Many thanks for your patience and quick answer. My cells
are formated for time. But when I try to custom format the
sum cell, I get an option of [hh]:mm:ss and not [hh]:mm as
you recomended below.

How do I change the format to what you recomend? I think
that will solve the problem.

Thanks again.

Hoque

-----Original Message-----
Hi
if all the cells are formated as times (no toher custom format) and
you're summing these cells, using the custom format [hh]:mm, should
return 56:15
Any chance there are some numers within, etc.

Frank

Sorry for the previous message.
This is what I have. And when custoemr format the cell as
[hh]:mm: ss I get 1347:33:00 and not 56:15.

Arrive
8:00 16:00 8:00
10:15 17:30 7:15
10:15 16:00 5:45
10:00 17:00 7:00
15:30 20:15 4:45
7:00 16:45 9:45
0:00
13:00 19:15 6:15
7:15 14:45 7:30
56.15

-----Original Message-----
Hi
just add your time values. e.g.
=A1+A2
where A1 = 04:30; A2 = 08:45
you may format the target cell with the custom format [hh]:mm if
your sum can exceed 24 hours

Frank



(e-mail address removed) wrote:
Hope everyone having a nice day.

I've number of cells with total time (i.e. 4hrs and 30 min
as 4:30 and so on). I want to add all of these times to
have a total hour and minutes. For the minutes, formula
should consider an hour for every 60 min. Such as, if I
have 4:30 and 8:45 in two different cells, sum of these
cells should be 13:15.

Hope it makes sense.
Thanks,


.

.