If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sum of total time in arange of cells
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, |
#2
|
|||
|
|||
Sum of total time in arange of cells
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 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, |
#3
|
|||
|
|||
Sum of total time in arange of cells
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 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, . |
#4
|
|||
|
|||
Sum of total time in arange of cells
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 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, . |
#6
|
|||
|
|||
Sum of total time in arange of cells
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 wrote: 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 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, . . |
#7
|
|||
|
|||
Sum of total time in arange of cells
Hi
Just choose the custome category and type this format code manually Frank wrote: 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 wrote: 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 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, . . |
Thread Tools | |
Display Modes | |
|
|