How add minutes to a date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

µ - 02 Nov 2006 17:23 GMT

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

Reply to this Message

Dave Peterson - 02 Nov 2006 17:46 GMT

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)

> Hi there,
>
[quoted text clipped - 5 lines]
>
> Thanks

Signature

Dave Peterson

Reply to this Message

µ - 02 Nov 2006 17:58 GMT

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)

Reply to this Message

CLR - 02 Nov 2006 17:59 GMT

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

> Hi there,
>
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message