Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
New date based on one date field minus minutes in another field
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.misc
|
|||
|
|||
New date based on one date field minus minutes in another field
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. " wrote: 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 | |||
Lookup to find the last value based on name and date field | Excel Discussion (Misc queries) | |||
Linked date field in worksheet defaults a blank field as 1/0/1900 | Excel Worksheet Functions | |||
Converting a date field into a month-year only field | Excel Discussion (Misc queries) | |||
sum multiple rows based on progressing date field on each row | Excel Worksheet Functions | |||
How to Join/concatenate a date field with a time field in Excel? | Excel Discussion (Misc queries) |