Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to: date field minus minutes equals new date
With
A1: (a date/time value....eg 12/25/2007 9:30:00 AM) B1: (number of minutes.......eg 15) This formula converts the number of minutes in B1 to a time value and subtracts it from A1 C1: =A1-B1/(24*60) Format C1 as Date/Time. Note: To Excel each date is a whole number (The number of days since 31-DEC-1899) Times are fractions of a day. Example: Noon is 0.50.......(half a day) Since B1 is "minutes", we need to divide it by the number of minutes in a day (24 hrs/day x 60 minutes/hour) Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New date based on one date field minus minutes in another field | Excel Discussion (Misc queries) | |||
how do I do this: today minus hire date equals how many years mo. | Excel Worksheet Functions | |||
Figuring Vacation Hrs. Earned using Current Date minus Hire Date | Excel Worksheet Functions | |||
Date minus date=No. of days? | Excel Worksheet Functions | |||
date (minus) date = working days diff | Excel Discussion (Misc queries) |