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
|