Add 10 minutes to a date/time value
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
|