View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Add 10 minutes to a date/time value

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 -