=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???