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 expert 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 repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
May 01, 2014 | Microsoft Excel for PC
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...
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
148 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: