Question about Microsoft Excel for PC

# 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

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

×

• 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

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

(Due Date - Create Date) / 24

Posted on Nov 17, 2008

×

• 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

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

Hi,
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).
goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### 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

### 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)

Oct 28, 2009 | Microsoft Excel for PC

### 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

### 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

### 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.

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

### 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

Mar 11, 2009 | Sharp EL-1197PIII Calculator

### 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 Computers & Internet

### 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)

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

Try it out!

Note: You will need to format the cells to Custom>mm/dd/yyyy

Nov 21, 2008 | Microsoft Excel for PC

### 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)

Aug 25, 2008 | Microsoft Office Professional 2007:...

### 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.

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.

Oct 22, 2007 | Microsoft Excel 2003 (06503995)

## Open Questions:

#### Related Topics:

149 people viewed this question

Level 3 Expert

Level 3 Expert