Add 10 minutes to a date/time value

  • Thread starter Thread starter Sarah G
  • Start date Start date
S

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
 
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
 
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.
 
Thank you

Pete_UK said:
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
Click to expand...
 
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
 
Back
Top