Question about Microsoft Excel for PC

3 Answers

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.

Posted by on

  • 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

  • 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

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

  • 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

(Due Date - Create Date) / 24

Posted on Nov 17, 2008

  • Danilo Mante
    Danilo Mante Nov 18, 2008

    (Due Date - Create Date) x 24

×

  • 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

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.

Posted on Nov 12, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Workday function in excel formulas


The WorkDay Function returns a number that's the serial date that is the indicated number of working days from a given date (the starting date). Working days EXCLUDE weekends and any dates identified as holidays. Use WORKDAY to exclude weekends or holidays when you calculate invoice due dates, expected delivery times, or the number of days of work performed.
The Syntax is:
=WORKDAY(start_date,days,holidays)
where:
- start_date is in Date format (and can be a calculated value);
- days is a number of elapsed days after start_date (can be calculated, can be negative to indicate a date BEFORE start_date);
- holidays is an array of holidays you can specify if desired.

May 01, 2014 | Microsoft Excel for PC

3 Answers

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

Sep 26, 2010 | Microsoft Excel for PC

1 Answer

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.

May 31, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

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

May 09, 2009 | Microsoft Office Excel 2003 for PC

2 Answers

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.

May 07, 2009 | Microsoft Excel 2007 Home and Student...

1 Answer

I need to create a macro where if one row matches with other row


create your formula
go to tools/macros/record macro/select your hot key <ctr+*>

Apr 03, 2009 | Microsoft Excel for PC

1 Answer

What is the formula,if a cell having start date of some batch, and i f i need to calculate the end date after 15 month ?


Use this forumla =EDATE(A1,15)

example in cell A1 you enter 3/11/2009 and in cell A3 you enter=EDATE(A1,15)

You will first see a serial number representing the new date. You must format cell A3 to display the value as a date. it should be:
6/11/2010

Mar 12, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

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.

Feb 22, 2009 | Microsoft Business & Productivity Software

1 Answer

CAN'T CALCULATE DATES TO GIVE DEADLINE


cell 1 (date format) = start date
cell 2 (number format) = number of days = cell 3 - cell 1
cell 3 (date format) = deadline = cell 1 + cell 2

Oct 16, 2008 | Microsoft Excel for PC

3 Answers

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!

Oct 22, 2007 | Microsoft Excel 2003 (06503995)

Not finding what you are looking for?
Microsoft Excel for PC Logo

148 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18304 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...