First, Excel doesn't work with dates before Jan 01, 1900 (on Windows), with earlier dates we work as with texts which represents the dates. If you have mix of 20th century and earlier dates it'll be safe to transform them all to texts first, i.e. warp by TEXT function as TEXT(C3...
Thank you for your response and feedback. The formula I originally inserted originally came from an excel macro that we use that does work but in a slightly different situation. I tried both formulas you provided and they do work , however, even though I changed the dates in Column B to ...
I need to calculate months, days, hours, minutes and seconds from date/time stamps: End time: 4/29/2019 11:36:59 AM (minus) Start time: 3/27/2019 2:27:52 AM = Active time (in months, days, hou... Jo_666To begin with, I would suggest you forget about the number o...
Order Delivery Time: <day> <hour>:<minute>:<second> There would be 3 equations that would need to be averaged 1. Placed Order with vendor datetime (minus) customer place order datetime = duration 2. Trucker at Vendor datetime (minus) Placed order with vendor datetime = duration...
I've tried DATEDIF function, INT function as well as using Cell Format. I can get part of what I need, but not all. Thanks so much!
{"id":"MicrosoftFooter","markupLanguage":"HANDLEBARS","style":".context-uhf {\n min-width: 280px;\n font-size: 15px;\n box-sizing: border-box;\n -ms-text-size-adjust: 100%;\n -webkit-text-size-adjust: 100%;\n & *,\n & *:before,\n & *:after {\n box-sizing...
{"id":"MicrosoftFooter","markupLanguage":"HANDLEBARS","style":".context-uhf {\n min-width: 280px;\n font-size: 15px;\n box-sizing: border-box;\n -ms-text-size-adjust: 100%;\n -webkit-text-size-adjust: 100%;\n & *,\n & *:before,\n & *:after {\n box-sizing: inh...
Excel calculating wrong Hello all, I am having an IFERROR challenge. Cell E26 contains the formula=IFERROR(C9+N9/$W9,0) C9 =2 N9 = 8 W9 = 61 2+8=10 10/61=0.1639 However, cell E26 is returning 213.11% La_La2346 Division has precedence above addition, so your formula adds N9/$...
{"id":"Featured_Resources","markupLanguage":"REACT","style":null,"texts":{"resourceTitle":"Title","titlePlaceholder":"Resource title","urlPlaceholder":"Resource URL","resourceUrl":"URL","addResource":"Add Resource","cancel":"Cancel","removeResource":"Remove Resource","error":"Error","...
First time on the community, so both excited and a bit nervous that I am putting this in the right way / place. Anyway, I have done a search for this question before, but I am not able to find a suggestion to my specific problem. ...