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

On Nov 9, 11:26*pm, Sarah G wrote:
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

Thank you

"Pete_UK" wrote:

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

On Nov 9, 11:26 pm, Sarah G wrote:
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

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

Pete

On Nov 10, 12:08*am, Sarah G wrote:
Thank you



"Pete_UK" wrote:
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

On Nov 9, 11:26 pm, Sarah G wrote:
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- Hide quoted text -

- Show quoted text -

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

=A1+TIME(0,10,0)

--
Rick (MVP - Excel)


"Sarah G" wrote in message
...
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

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.
--
Thanks,
Shane Devenshire


"Sarah G" wrote:

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 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: EditCopy
Select the range A1:A10
Then: EditPaste SpecialAddOK
You may have to reformat the dates
Delete cell B1

--
Biff
Microsoft Excel MVP


"Sarah G" wrote in message
...
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

To add 10 minutes to a date/time value in Microsoft Excel, use the following formula:

In this formula, A1 is the cell containing the original date/time value that you want to add 10 minutes to. The TIME function takes three arguments: hours, minutes, and seconds. In this case, we want to add 10 minutes, so we use 0 hours, 10 minutes, and 0 seconds.

Here are the steps to follow:

1. Select the cell where you want to display the result.
2. Type the equal sign (=) to start the formula.
3. Click on the cell containing the original date/time value.
4. Type a plus sign (+) to indicate that you want to add something to the original value.
5. Type the TIME function with the arguments (0,10,0) to add 10 minutes.
6. Press Enter to complete the formula.

The result should be the original date/time value plus 10 minutes.