View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default how to minus the time value

Please accept my apologies: I do not fully understand your question.
However, if you have a time value in a cell you can add or subtract
five minutes from that value with this value:
=5/(24*60)

.... which is the Excel equivalent of 5 minutes.

Dave O