Question about Microsoft Excel for PC
This is what i need to do.
I need to calculate accumulated hours from two inputs.
Create date: 10/19/2008 13:08
Due date: 10/23/2008 13:08
then i need a formula that will calculate how many hours have accumulated from create date to due date.
As stated, the forumla solution in is
= (Due Date - Create Date) x 24
However, the key is that the result cell (where the formula is) should be formatted using the 'general' format, not date/time. So, I think in this example, the result should be 730.65 hours
Posted on Feb 19, 2009
If your asking what i think you are the formula would be
That assumes a2 is that last date entered and a1 is the initial starting date. if you would like a more intense formula let me know and i'm sure i can help.
Posted on Nov 12, 2008
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Sep 26, 2010 | Microsoft Excel for PC
May 31, 2009 | Microsoft Office Excel 2003 for PC
May 09, 2009 | Microsoft Office Excel 2003 for PC
May 07, 2009 | Microsoft Excel 2007 Home and Student...
Mar 11, 2009 | Sharp EL-1197PIII Calculator
Feb 22, 2009 | Microsoft Computers & Internet
Nov 21, 2008 | Microsoft Excel for PC
Aug 25, 2008 | Microsoft Office Professional 2007:...
Oct 22, 2007 | Microsoft Excel 2003 (06503995)
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Jul 23, 2013 | Microsoft Excel for PC
155 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: