Add 10 minutes to a date/time value

[Sarah G]

I need to add 10 minutes to a date time field. How should this formulae read
10/11/2008 15:35:00 plus 10 mins would equal 10/11/2008 15:45:00

Thank you

 

[Pete_UK]

If you have 10/11/2008 15:35:00 in A1, then you can use this in, say,
B1:

=A1+10/(24*60)

as times are stored internally as fractions of a 24-hour day.

Hope this helps.

Pete

 

[Rick Rothstein]

Assuming you time is in A1, give this a try...

=A1+TIME(0,10,0)

 

[ShaneDevenshire]

Hi,

Suppose A1 contains
10/11/2008 15:35:00
In B1 enter
=A1+1/144
or
=A1+10/1440
or
=A1+TIME(,10,)

If this helps, please click the Yes button.

 

[Sarah G]

Thank you

If you have 10/11/2008 15:35:00 in A1, then you can use this in, say,
B1:

=A1+10/(24*60)

as times are stored internally as fractions of a 24-hour day.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome, Sarah - thanks for feeding back.

Pete

 

[T. Valko]

If you want to do this to a whole range of cells you can do it in-place
without the need for a separate cell and a formula.

Assume A1:A10 are dates/times you want to add 10 mins to.

Enter 0.00694 in an empty cell. This is the decimal equivalent of 10 mins.

Assume you enter that number in cell B1
Copy cell B1: Edit>Copy
Select the range A1:A10
Then: Edit>Paste Special>Add>OK
You may have to reformat the dates
Delete cell B1