Tech Support
Local Repair
Reviews & Ratings

Join | Answer Questions | Sign In

Help me with
Search
Home | Microsoft | Excel for PC | Need excel solution
Microsoft Excel for PC
Problem for Microsoft Excel for PC

Need excel solution




By ycool11 on Oct 22, 2008

" "
This is what i need to do.

I need to calculate accumulated hours from two inputs.

example.

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.

Thanks.

Comments:

Nov 15, 2008

- it did not work, here are the inputs i tried and hours is the result with your formula.

A2 - DUE DATE 11/14/2008 20:24

A1 - CREATE DATE 10/15/2008 9:45

=(A2-A1)*24 - HOURS 12/30/1901 15:48

result with formula: 12/30/1901 15:48
Ads by Google

Same Problem

Feb 18, 2009

-   Hi, I Have the same problem ...can somebody help me out.


Collection Actual Arrival TAT up to Date Time Date Time 31-Jan-09 14.09 1-Feb-09 9.05 31-Jan-09 14.09 1-Feb-09 9.05 30-Jan-09 17.18 1-Feb-09 9.05 -   kathu_aadim

Nov 09, 2008

-   need excel 2003 & 2007 solutions
-   onlysharmaji

Best Solution

posted on Feb 19, 2009
Very Helpful)

tnt_guy
tnt_guy

Rank: Wiz 
Rating: 92%, 83 votes
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
Was this helpful?
Yes
No

Solution #2

posted on Nov 17, 2008
Very Helpful)

danilomanjr
danilomanjr

Rank: Wiz  Microsoft Expert
Rating: 81%, 20 votes
(Due Date - Create Date) / 24
Comments:

Nov 18, 2008

- (Due Date - Create Date) x 24
Was this helpful?
Yes
No

Solution #3

posted on Nov 12, 2008
Very Helpful)

Eeeeeeeeeekz
Eeeeeeeeeekz

Rank: Wiz  Microsoft Expert
Rating: 80%, 93 votes
Hello ycool11, If your asking what i think you are the formula would be
=(a2-a1)*24
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.
Was this helpful?
Yes
No

Popular Solutions for Microsoft Excel for PC


Excel for PC
Microsoft Excel for PC
I want to down load the excel software
I want to down load the excel software
2 Solutions

Excel for PC
Microsoft Excel for PC
I have just saved my excel spreadsheet and...
I have just saved my excel spreadsheet and the file has become corrupted. How can I...
1 Solution

Excel for PC
Microsoft Excel for PC
microsoft excel file dose not open...
Dear sir when i open a excel file by double click , microsoft excel is only opening...
3 Solutions

Excel for PC
Microsoft Excel for PC
I only have pc access at my mom's...
I only have pc access at my mom's retirement center and want to buy and download ez...
1 Solution

Excel for PC
Microsoft Excel for PC
I can put my cursor in the first cell of...
I can put my cursor in the first cell of any page (ex. user name), but can not click...
1 Solution

Questions and Unsolved Problems for Microsoft Excel for PC


Do you recommend Microsoft Excel for PC?
Answer

Microsoft Excel for PC
Microsoft Excel for PC

microsoft excel

Answer
bcoz i dont microsoft excell2007

Microsoft Excel for PC
Microsoft Excel for PC

Xbox Live Setup

Answer
how can u get the pc download to Xbox

Microsoft Excel for PC
Microsoft Excel for PC

what is formula to use 5 point drop...

Answer
I am writing a user spreadsheet that requires a couple of drop down choices to prompt automatic cell... (More)

Microsoft Excel for PC
Microsoft Excel for PC

what is formula to use 5 point drop...

Answer
what is formula to use 5 point drop down list to prompt entry of cell value into specific location

Microsoft Excel for PC
Microsoft Excel for PC

using an excel sheet, assume that...

Answer
using an excel sheet, assume that sum of some cells is 100.77 and i want to use this sum in other... (More)


Didn't find what you were looking for?

Describe your Business and Productivity... problem:


Ads by Google



Ask our Experts

Ask

 

Solve Your Problem Now!
Chat Live with an Expert
Chat Now
Top Business and... Experts
lfete
Rank:
Wiz
Computer Software
Expert

Rating:
81%, 143 votes


smb_146
Rank:
Guru
Computer Software
Expert

Rating:
98%, 371 votes


cameleon_one
Rank:
Wiz
Computer Software
Expert

Rating:
82%, 80 votes


Find more Business and... Experts
Top Computer & Laptop Repairmen
in Windham, ME
Zkarlo.com
(952) 890-7770
Zkarlo.com provides discount and used laptop parts...
Zkarlo.com

LaptopOnCall Inc.
(513) 874-3306
We fix and repair laptop motherboard no video, no...
LaptopOnCall Inc.

See More
Get Listed!

       
Solve Your Problem Now!
Chat Live with an Expert
Chat Now

Insert Link
Insert Image
Insert You-Tube clip
Insert List
Insert List
Spell Check

What is this?



Select