View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 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