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
 
D

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)
 
C

CLR

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
 
Top