Sum of total time in arange of cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,
 
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
 
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



[email protected] said:
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,
Click to expand...


.
Click to expand...
 
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



[email protected] said:
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,
Click to expand...


.
Click to expand...
 
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,
Click to expand...


.
Click to expand...
Click to expand...
 
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


[email protected] said:
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
Click to expand...
Click to expand...
[hh]:mm if
your

.
Click to expand...
 
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,


.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top