Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding hours and minutes
I am trying to add hours an dminutes within a cell. The only help hints I
can find tell you how to add hours & minutes when referencing an outside cell. My problem is within one cell I need to find a formula to add 7 hours 35 minutes plus 20 hours and 58 minutes. I can a whole bunch of crazy numbers - but I can never get it to be the 28 hours and 33 minutes it should be. I have a spreadsheet where I will have to continully be adding in additional hours into each cell and I don't want to have to manually add them if Excel can do it for me. Can anyone help??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding hours and minutes
=SUM(A1:A2)
Fomat cells as: [h]:mm "Breezy77" wrote: I am trying to add hours an dminutes within a cell. The only help hints I can find tell you how to add hours & minutes when referencing an outside cell. My problem is within one cell I need to find a formula to add 7 hours 35 minutes plus 20 hours and 58 minutes. I can a whole bunch of crazy numbers - but I can never get it to be the 28 hours and 33 minutes it should be. I have a spreadsheet where I will have to continully be adding in additional hours into each cell and I don't want to have to manually add them if Excel can do it for me. Can anyone help??? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding hours and minutes
I am trying to add hours an dminutes within a cell. The only help hints I
can find tell you how to add hours & minutes when referencing an outside cell. Not sure what you mean by that. A1 = 7:35 A2 = 20:58 If you need to enter times 24:00, like: 34:45 Format the cells as [h]:mm =SUM(A1:A2) = 28:33 Format the formula cell as [h]:mm -- Biff Microsoft Excel MVP "Breezy77" wrote in message ... I am trying to add hours an dminutes within a cell. The only help hints I can find tell you how to add hours & minutes when referencing an outside cell. My problem is within one cell I need to find a formula to add 7 hours 35 minutes plus 20 hours and 58 minutes. I can a whole bunch of crazy numbers - but I can never get it to be the 28 hours and 33 minutes it should be. I have a spreadsheet where I will have to continully be adding in additional hours into each cell and I don't want to have to manually add them if Excel can do it for me. Can anyone help??? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding hours and minutes
I am not adding from two different cells. I currently have 7 hours and 35
minutes in Cell A1 and need to add 20 Hours and 58 minutes to this total. The 20:58 is not in any other cell - it is just a number that needs to be added. "T. Valko" wrote: I am trying to add hours an dminutes within a cell. The only help hints I can find tell you how to add hours & minutes when referencing an outside cell. Not sure what you mean by that. A1 = 7:35 A2 = 20:58 If you need to enter times 24:00, like: 34:45 Format the cells as [h]:mm =SUM(A1:A2) = 28:33 Format the formula cell as [h]:mm -- Biff Microsoft Excel MVP "Breezy77" wrote in message ... I am trying to add hours an dminutes within a cell. The only help hints I can find tell you how to add hours & minutes when referencing an outside cell. My problem is within one cell I need to find a formula to add 7 hours 35 minutes plus 20 hours and 58 minutes. I can a whole bunch of crazy numbers - but I can never get it to be the 28 hours and 33 minutes it should be. I have a spreadsheet where I will have to continully be adding in additional hours into each cell and I don't want to have to manually add them if Excel can do it for me. Can anyone help??? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding hours and minutes
=G1+(20/24)+(58/24/60)
where G1 holds 7:35 you can also use =G1+TIME(20,58,) as long as you don't add more than 24 hours note that you still need to custom format the cell as [hh]:mm or else you will get 04:33 for the first formula and 01/01/00 04:33 for the second -- Regards, Peo Sjoblom "Breezy77" wrote in message ... I am not adding from two different cells. I currently have 7 hours and 35 minutes in Cell A1 and need to add 20 Hours and 58 minutes to this total. The 20:58 is not in any other cell - it is just a number that needs to be added. "T. Valko" wrote: I am trying to add hours an dminutes within a cell. The only help hints I can find tell you how to add hours & minutes when referencing an outside cell. Not sure what you mean by that. A1 = 7:35 A2 = 20:58 If you need to enter times 24:00, like: 34:45 Format the cells as [h]:mm =SUM(A1:A2) = 28:33 Format the formula cell as [h]:mm -- Biff Microsoft Excel MVP "Breezy77" wrote in message ... I am trying to add hours an dminutes within a cell. The only help hints I can find tell you how to add hours & minutes when referencing an outside cell. My problem is within one cell I need to find a formula to add 7 hours 35 minutes plus 20 hours and 58 minutes. I can a whole bunch of crazy numbers - but I can never get it to be the 28 hours and 33 minutes it should be. I have a spreadsheet where I will have to continully be adding in additional hours into each cell and I don't want to have to manually add them if Excel can do it for me. Can anyone help??? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding hours and minutes
I am not trying to add cells together. What I am trying to do is take a cell
that currently has 7 hours and 35 minutes in it and add 10 hours and 58 minutes to that 7:35. The 10:58 is not located in any other cell - it is simply a number from a piece of paper I receive that I need to add to the original 7:35. Is it possible to do this? "Teethless mama" wrote: =SUM(A1:A2) Fomat cells as: [h]:mm "Breezy77" wrote: I am trying to add hours an dminutes within a cell. The only help hints I can find tell you how to add hours & minutes when referencing an outside cell. My problem is within one cell I need to find a formula to add 7 hours 35 minutes plus 20 hours and 58 minutes. I can a whole bunch of crazy numbers - but I can never get it to be the 28 hours and 33 minutes it should be. I have a spreadsheet where I will have to continully be adding in additional hours into each cell and I don't want to have to manually add them if Excel can do it for me. Can anyone help??? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding hours and minutes
Is there any way to add MORE than 24 hours?
"Peo Sjoblom" wrote: =G1+(20/24)+(58/24/60) where G1 holds 7:35 you can also use =G1+TIME(20,58,) as long as you don't add more than 24 hours note that you still need to custom format the cell as [hh]:mm or else you will get 04:33 for the first formula and 01/01/00 04:33 for the second -- Regards, Peo Sjoblom "Breezy77" wrote in message ... I am not adding from two different cells. I currently have 7 hours and 35 minutes in Cell A1 and need to add 20 Hours and 58 minutes to this total. The 20:58 is not in any other cell - it is just a number that needs to be added. "T. Valko" wrote: I am trying to add hours an dminutes within a cell. The only help hints I can find tell you how to add hours & minutes when referencing an outside cell. Not sure what you mean by that. A1 = 7:35 A2 = 20:58 If you need to enter times 24:00, like: 34:45 Format the cells as [h]:mm =SUM(A1:A2) = 28:33 Format the formula cell as [h]:mm -- Biff Microsoft Excel MVP "Breezy77" wrote in message ... I am trying to add hours an dminutes within a cell. The only help hints I can find tell you how to add hours & minutes when referencing an outside cell. My problem is within one cell I need to find a formula to add 7 hours 35 minutes plus 20 hours and 58 minutes. I can a whole bunch of crazy numbers - but I can never get it to be the 28 hours and 33 minutes it should be. I have a spreadsheet where I will have to continully be adding in additional hours into each cell and I don't want to have to manually add them if Excel can do it for me. Can anyone help??? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding hours and minutes
You can use Peo's first example:
=A1+(hours/24)+(minutes/1440) For example: A1 = 7:35 Add 35:10 =A1+(35/24)+(10/1440) Format as [h]:mm or [hh]:mm The difference in formats is that [hh]:mm will give you a leading 0 when the hours is a single digit. Like this: [h]:mm = 9:10 [hh]:mm = 09:10 -- Biff Microsoft Excel MVP "Breezy77" wrote in message ... Is there any way to add MORE than 24 hours? "Peo Sjoblom" wrote: =G1+(20/24)+(58/24/60) where G1 holds 7:35 you can also use =G1+TIME(20,58,) as long as you don't add more than 24 hours note that you still need to custom format the cell as [hh]:mm or else you will get 04:33 for the first formula and 01/01/00 04:33 for the second -- Regards, Peo Sjoblom "Breezy77" wrote in message ... I am not adding from two different cells. I currently have 7 hours and 35 minutes in Cell A1 and need to add 20 Hours and 58 minutes to this total. The 20:58 is not in any other cell - it is just a number that needs to be added. "T. Valko" wrote: I am trying to add hours an dminutes within a cell. The only help hints I can find tell you how to add hours & minutes when referencing an outside cell. Not sure what you mean by that. A1 = 7:35 A2 = 20:58 If you need to enter times 24:00, like: 34:45 Format the cells as [h]:mm =SUM(A1:A2) = 28:33 Format the formula cell as [h]:mm -- Biff Microsoft Excel MVP "Breezy77" wrote in message ... I am trying to add hours an dminutes within a cell. The only help hints I can find tell you how to add hours & minutes when referencing an outside cell. My problem is within one cell I need to find a formula to add 7 hours 35 minutes plus 20 hours and 58 minutes. I can a whole bunch of crazy numbers - but I can never get it to be the 28 hours and 33 minutes it should be. I have a spreadsheet where I will have to continully be adding in additional hours into each cell and I don't want to have to manually add them if Excel can do it for me. Can anyone help??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding up hours and minutes | Excel Discussion (Misc queries) | |||
Adding hours and minutes | Excel Worksheet Functions | |||
Adding hours and minutes | Excel Discussion (Misc queries) | |||
Adding hours and minutes.. | Excel Discussion (Misc queries) | |||
adding hours and minutes | New Users to Excel |