How add minutes to a date

[µ]

Hi there,

I've got in a cell a time in this format 04/03/2006 14:34 and I want
to add the value of a cell that respresents minutes tot that one cell.

So if the cell contains 22, i want to add 22 minutes to the first cell
that returns 04/03/2006 14:56

Thanks

 

[Dave Peterson]

If it's really a date/time, you could use:
=a1+time(0,22,0)

or if b1 contains that 22:
=a1+(b1/24/60)

 

[µ]

Did I ever tell you, you are great?
Thanks

If it's really a date/time, you could use:
=a1+time(0,22,0)

or if b1 contains that 22:
=a1+(b1/24/60)

 

[Guest]

if A1 contains your "04/03/2006 14:34" and B1 contains 22, then put this in C1

=A1+(0.000694444*B1)

Vaya con Dios,
Chuck, CABGx3