View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Add 10 minutes to a date/time value

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