New date based on one date field minus minutes in another field

  • Thread starter Thread starter jdtobias
  • Start date Start date
J

jdtobias

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!
 
Divide the minutes by 1440 (the number of minutes in a day) and subtract. If
the values are in A1 and B1, then =a1-b1/1440.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to: date field minus minutes equals new date 2
Excel Subtracting multiple columns from another column 3
Access Access - Is it possible to repeat fields in a form? 1
Formula to add 12 months to an existing date field 3
Date range within a date range 2
Excel How to get the number of days an item was opened from the today's date. 14
HELP! IF Statements Comparing Date/Time Entries (yyyy-mm-dd hh:mm 1
Sumproduct based on date entered in separate field 3

Back
Top