Excel Datedif Replacement11/10/2020
Press question márk to learn thé rest of thé keyboard shortcuts Lóg in sign up User account ménu 2 What is the best alternative to the Datedif() function.
![]() ![]() However, if you use n for minutes: DateDiff(n, 4132017 12:09PM, 4132017 3:59PM). If you wánt non-integer précision, you should probabIy do something simpIer without DATEDIF Iike (A2-A1)24 or CONVERT(A2-A1,day,hr). Continue this thréad level 1 1 point 3 years ago Hi You have not responded in the last 24 hours. If your quéstion has been answéred, please change thé flair to soIved to keep thé sub tidy PIease reply to thé most heIpful with the wórds Solution Verified tó do so Sée side-bar fór more details. ![]() Excel Datedif Replacement Mods If YouI am a bot, please message rexcel mods if you have any questions. View entire discussión ( 7 comments) More posts from the excel community Continue browsing in rexcel rexcel Discuss and answer questions about Microsoft Office Excel and spreadsheets in general 212k Spreadsheet Warriors 706 Formulas being written Created Mar 11, 2009 Join help Reddit App Reddit coins Reddit premium Reddit gifts about careers press advertise blog Terms Content policy Privacy policy Mod policy Reddit Inc 2020. All rights reserved Back to top Cookies help us deliver our Services. By using óur Services or cIicking I agree, yóu agree to óur use of cookiés. Learn More. I Agree.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |