Thread: How to: date field minus minutes equals new date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dst dst is offline
external usenet poster
  
Posts: 1
Default How to: date field minus minutes equals new date
I have a worksheet that has 1 field with the full date, e.g. 12/25/2007 09:30
(field A) and another field that has minutes, e.g. 15. (field B) I want a
formula that can tell me the new date/time if I take field A and deduct field
B. thanks!
Reply With QuoteReply With Quote