Microsoft Excel for PC Logo
Posted on Oct 22, 2008
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

Need excel solution

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.

Answer This Question
  • 1 more comment 
  • onlysharmaji Nov 09, 2008

    need excel 2003 & 2007 solutions

  • ycool11 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

  • kathu_aadim 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

×

3 Answers

Anonymous

Level 1:

An expert who has achieved level 1.
MVP:

An expert that got 5 achievements.
Governor:

An expert whose answer got voted for 20 times.
Hot-Shot:

An expert who has answered 20 questions.

  • Contributor 35 Answers
  • Posted on Feb 19, 2009
Anonymous
Contributor
Level 1:

An expert who has achieved level 1.
MVP:

An expert that got 5 achievements.
Governor:

An expert whose answer got voted for 20 times.
Hot-Shot:

An expert who has answered 20 questions.

Joined: Dec 12, 2007
Answers
35
Questions
0
Helped
83009
Points
89

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

Danilo Mante

Danilo Mante

Level 1:

An expert who has achieved level 1.
Hot-Shot:

An expert who has answered 20 questions.
Corporal:

An expert that has over 10 points.
Mayor:

An expert whose answer got voted for 2 times.

  • Contributor 45 Answers
  • Posted on Nov 17, 2008
Danilo Mante
Contributor
Level 1:

An expert who has achieved level 1.
Hot-Shot:

An expert who has answered 20 questions.
Corporal:

An expert that has over 10 points.
Mayor:

An expert whose answer got voted for 2 times.

Joined: Nov 17, 2008
Answers
45
Questions
0
Helped
11928
Points
50

(Due Date - Create Date) / 24

  • Danilo Mante
    Danilo Mante Nov 18, 2008

    (Due Date - Create Date) x 24

×

Ad

Eeeeeeeeeekz

Level 2:

An expert who has achieved level 2 by getting 100 points
MVP:

An expert that got 5 achievements.
Scholar:

An expert who has written 20 answers of more than 400 characters.
Hot-Shot:

An expert who has answered 20 questions.

  • Expert 120 Answers
  • Posted on Nov 12, 2008
Eeeeeeeeeekz
Expert
Level 2:

An expert who has achieved level 2 by getting 100 points
MVP:

An expert that got 5 achievements.
Scholar:

An expert who has written 20 answers of more than 400 characters.
Hot-Shot:

An expert who has answered 20 questions.

Joined: Nov 11, 2008
Answers
120
Questions
0
Helped
80112
Points
217

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.

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

44helpful
3answers

Pls help to write an excel formula to display date, thanks! Cell A1 input a date - 1 Sep 10, Cell B1 write a formula to calculate & display the date which = (A1 + 14 days but if the result is a...
This is too complicated for a help site like this, you are going to want to consult an excel forum, or some excel professional in your area. This is far beyond the scope of what you can expect for $15, which I'm sure you now realize after 10 days of trying.

Thanks
Tim
Read full answer
Sep 26, 2010 • Microsoft Excel for PC
0helpful
1answer

Need help with excel formula
The solution would be to have an input column(e.g. A) that is separate to the hours and overtime columns. Then in the hours column enter =IF(A1<40,A1,40) and in the overtime column =IF(A1<41,0,A1-40)
Read full answer
Oct 28, 2009 • Microsoft Excel for PC
0helpful
1answer

Reminder in excel
There are a couple of types of spreadsheet - Depending on the size of the data you are working with - filter may the quickest option or Query report.

Your worksheet will contain all your data i.e. Customer, contact no, outstaning actions and due date - You can create a filter aon this set criteria on the due data - as less than or equal to todays date - which will only display your outstanding actions required by today or earlier.

Another option if you have installed MS Query, is to create a seperate report - again using the criteria of due date being less than or equal to today.

Producing this from your existing data is much easier than trying to re-create your data - But I can send you how I would create this sheet if the above explanation is not easy to follow - If you let me have your email address.
Read full answer
May 31, 2009 • Microsoft Office Excel 2003 for PC
0helpful
1answer

Calculate Quarters between any two dates
not sure if this is what you are after entirely but should at least help you out some what

=DATEDIF(A3,C3,"m")/3

As you said you cant just divide by 3 but I have divided the formula by 3 to see how many 3 months will go into the output you could maybe have another formula to divide it by 2 to see if it will divide by 2 to see if you get a whole number or not, if you do then you can just return the first part before the dot ( using split function ) and if the value is less then 1 then obviously the 3 months has not passed between the 2 dates
Read full answer
May 09, 2009 • Microsoft Office Excel 2003 for PC
1helpful
2answers

Writing a formula for a sumif problem
Brenda,

Your problem is not so much the formula but the cells that contain the hours for each call. Since they contain the text “hrs” (for example “2.25hrs”) this turns the whole cell to text, not numeric, which will always add up to zero in Excel. So do two things:
- Change the cells in column H (Time Spent) to numeric (2.25 instead of 2.25hrs) – you might want to change the column header to Time Spent In Hrs just to b clear
- Use this formula =SUMIF(E8:E26, 1, H8:H26)
For the formula change the middle number to correspond to the operator ID – for example for operator 2 change the formula to =SUMIF(E8:E26, 2, H8:H26)

This should do it.

BTW, sent you a similar email about this.
Read full answer
May 07, 2009 • Microsoft Excel 2007 Home and Student...
35helpful
2answers

Need to change the time on calculator
To set up date, time, conversion rate, and tax/discount
rate, place the switch at the "RATE SET" position.
Date:
• Enter in the order of month, day and year, then press date/time button
to complete the entry.
• Use ▪ to separate month, day, and year EXAMPLE 3▪13▪2009.
• When (date/time) button is pressed, the number entered is evaluated
and displayed as “date”
Time:
• Enter in the order of hour, minutes, then press date/time button to
complete the entry.
(There is no entry available for the seconds value. The
clock starts at zero second.)
• Use ▪ to separate hour and minute values EXAMPLE 8▪15
• When is date/time button is pressed, the number entered is evaluated
and displayed as “time

When settings are complete place the switch back to GT
Read full answer
Mar 11, 2009 • Sharp EL-1197PIII Calculator
0helpful
1answer

Procedure how to establish aging of account receivable in excel
Once your data has been input into Excel - I assume you can do this via importing an outstanding debtors deport.

The easiest way I can see is by Pivot Table.

Your data should include open invoices and their respective due dates, it will be easier if you could covert these due dates into months - Create a pivot entering customer, outstanding values as your data and due months as your range.
Read full answer
Feb 22, 2009 • Microsoft Computers & Internet
0helpful
1answer

Need to Add Dates in Excel
Here is one way I just tried:

Say the date purchased is in A1.

You want the Est Life in A2.

In A2 type: =A1+(3*365)
That will add 3 years.

For 5 years: =A1+(5*365)

Try it out!

Note: You will need to format the cells to Custom>mm/dd/yyyy
Read full answer
Nov 21, 2008 • Microsoft Excel for PC
0helpful
2answers

Formula for calculating the days beween months
for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)
Read full answer
Aug 25, 2008 • Microsoft Office Professional 2007:...
0helpful
3answers

Excel argument
If I understand correctly, you want to figure the normal wages at 40 hours and less. If there is more then 40 hours, calculate the normal 40 hours, then calculate the hours overtime (time and a half) and add them to get a total.

2bef84b.png

B5 columns are filled with this:
=IF(A5>$B$1,($B$2*$B$1)+((A5-$B$1)*($B$3)),A5*$B$2)

NOTE: The $ sign doesn't refer to money, it refers to an absolute reference so when copying a formula, the cell references with a $ sign are fixed and don't adjust according to the relative position to where it's being pasted.

Please rate as FixYa! or ask please clarify. ThankYa!
Read full answer
Oct 22, 2007 • Microsoft Excel 2003 (06503995)
Not finding what you are looking for?

View Most Popular

Excel for PC

  • Computers & Internet

Related Question

Pls help to write an excel formula to display date, thanks! Cell A1 input a date - 1 Sep 10, Cell B1 write a formula to calculate & display the date which = (A1 + 14 days but if the result is a...

  • Microsoft Excel for PC

Related Topics

194 views

Ask a Question

Usually answered in minutes!

Popular Questions

CSV file to Import correctly into Excel 2003

Microsoft Excel for PC

Indian Rupee format in Excel spreadsheet

Microsoft Excel for PC

How to select all sales entry in tally 9 and how to delete it

Microsoft Excel for PC

Excel file opens in read only mode

Microsoft Excel for PC

Using excel to solve problem by trial and error method

Microsoft EXCEL 2004 for Mac

Check Out the Mobile Browsers Report
Check Out the Mobile Browsers Report

View all Fixya Reports

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...