Thread: How to: date field minus minutes equals new date
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default How to: date field minus minutes equals new date
Another one...

If the unit to subtract always represents minutes:

=A1-TIME(,B1,)

--
Biff
Microsoft Excel MVP


"dst" wrote in message
...
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