Question about Microsoft Excel for PC
The formula is off by 11 minutes?
=(DATEDIF(A12,B12,"d")*9)+((B12-INT(B12))*24-(A12-INT(A12))*24)
Please be more clear with the question.. Do you want me to analyze the formula?
Posted on Feb 21, 2008
strange i have checked it myself... its perfect! Don't know where its going wrong..But i will talk to other experts and let you know..
Do you want the formula to be for a month or year?
Can you plase get me the spread sheet you have used for this? You can upload it on rapidshare and provide me the link.. The problem is that i have some missing info like what is "d" and also the format of spreadsheet you are going to use this on
×
Jan 01, 2010 | Microsoft Excel 2007 Home and Student...
Mar 20, 2009 | Microsoft Excel for PC
Mar 11, 2009 | Microsoft Office Excel 2003 for PC
Mar 09, 2009 | Microsoft Office Professional 2007 Full...
Dec 02, 2008 | Microsoft Office Professional 2007 Full...
Oct 22, 2008 | Microsoft Excel for PC
Sep 14, 2008 | Business & Productivity Software
Mar 20, 2008 | Business & Productivity Software
Mar 05, 2008 | Microsoft Excel for PC
Mar 03, 2008 | Business & Productivity Software
Jan 28, 2016 | Microsoft Excel for PC
91 people viewed this question
Usually answered in minutes!
Yes please. I know the basic formula is correct. I just need to find that extra 11 minutes.
I would appreciate that.
I need to exclude weekends and holidays from this formula. How can we accomplish this?
It should be for the year. and the month please. In other words I need one for the month and one for the year. Thank you.
×