Good Day,

I have two cells in my Excel file that contains the Start and Stop time, I was able to get the time difference between the 2 cells. Their cell format is dd/mm/yyyy 00:00 PM/AM (Custom).

I want to get the time differential (night shift) between the two cells but I can't figure it out. Night shift starts at 10:00 PM - 6:00 AM (next day), please see sample below.

C2: 08-July-2010 8:00 PM (Start)

D2: 09-July-2010 8:00 AM (Stop)

Would appreciate if you could help me build a formula to get the time accumolated for night differential.

Thank you.

I have two cells in my Excel file that contains the Start and Stop time, I was able to get the time difference between the 2 cells. Their cell format is dd/mm/yyyy 00:00 PM/AM (Custom).

I want to get the time differential (night shift) between the two cells but I can't figure it out. Night shift starts at 10:00 PM - 6:00 AM (next day), please see sample below.

C2: 08-July-2010 8:00 PM (Start)

D2: 09-July-2010 8:00 AM (Stop)

Would appreciate if you could help me build a formula to get the time accumolated for night differential.

Thank you.

- How to calculate length of stay
- ACC2000: How to Calculate Row-Level Statistics
- How to calculate total for closed order only?
- How to Calculate Textbox's Please Help!
- How to calculate the area under the curve in the excel?
- How to Calculate an unknown number?
- How to calculate the day before last two working day of each month
- How to calculate return on a open-ended mutual fund?
- How to calculate pass/fail percentages entered on a spreadsheet?
- How to calculate years, months by using one formula
- RE: How to calculate a pay-back period by the accumulated cash-flow au
- How to calculate probability of an event will happen multipe times in a row
- How to calculate an Average of a count
- How to calculate the difference between 2 times of day & show 1/2 hr as .5 & not .3
- How to calculate hours across a specified shift..
- How to calculate percentage
- How to calculate something using equation from Chart' directly?
- How to Calculate an unknown number?
- How to calculate conditional sum?
- How to calculate the # of Sundays between two dates
- How to calculate a pay-back period by the accumulated cash-flow automaticall
- How to calculate the accumulated payments from an annuity at yr 10
- How to calculate with years....?
- How to calculate the cumulative weekly average over several wksht

I have two dates for check in and check out and I need to calculate length of stay.

The following example:

today() is 01/17/2011

VB:How to calculate the customer count today based on checked in and not checked out yet ( column B is empty)A B C check In check out length of stay 01/05/2011 01/10/2011 5 =If(ISBLANK(B2),SUM(TODAY()-A2),SUM(B2-A2)) 01/05/2011 12 01/05/2011 01/15/2011 10If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

Thanks in advance.

... Microsoft Access has several built-in functions that enable you to perform statistical ... For more information about statistical formulae, click Microsoft Excel Help on the Help ...

How to calculate total for closed order only?

Exapmel:

Or Here:

[img=http://aycu32.webshots.com/image/44751/2005401807983014304_th.jpg]

Regards.

Heres What it looks like:

Enter Loan Amount: (TextBox1)

Enter the Amount of Months in the loan: (Textbox2)

Enter Anual Interest Rate: (TextBox3)

BUTTON: CALCULATE MONTHLY FEE!

I am trying to display the monthly fee in Listbox3!

Thank You!!

I'm basically trying to perform algebraic equations with excel.

Could someone give me a hand with this theoretical question:

A man, when asked by his niece how old he was, replied, "My age is now four

times yours, but five years ago it was five times yours." How old was he?

28th of June, 27th of July, 29th of August, 28th of Sept...?

investor can invest at different points of time at different NAV and offload

the investment at a certain NAV.

column to say pass one to say fail and calculate the percentage of each on a

monthly basis. I can enter the info but don't know how to calculate the

percentages

Example

01/10/1977 and 10/04/2002 . i want to know the formula for getting correct

years, months and days between above dates

I assume that you actually want to add the negative values and positive

values seperately. To compute the sum of negative values and positive

values, use the sumif funtion.

Regards,

"Dmitry Kopnichev" wrote:

> Hello

> How to calculate a pay-back period by the accumulated cash-flow

> automatically? How to count number of negative values in a row range? How to

> count ratio of a first positive value to module of the last negative value

> automatically?

>

>

I also want to calculate what is the probability of happening U after 3 Us, for instance. What is the probability that 2, 3, 4 Overs or Unders happen in a row?

The data in the attached file is just small par of the data that i'll be analising .

I have tickets numbers in this format (111122 , 222333,..etc) , those Tickets numbers are not considered as numbers.

what i am able to do is to count those tickets monthly / quarterly which is OK..

but what i need is how to : calculate the average of the count Quarterly = count (month1)+count(month2) + count (month3) / 3 ..

Any help will be appreciated

thanks

I have cell D4 and E4 that show a start time and finish time of a shift (eg D4 is 21:30 and E4 is 23:59). I have figured out how to calculate how many hours it is, and how to round the figure to the next 1/2 hour:

=ROUND(SUM(E4-D4)*48,0)/48

The problem with this is that it shows the result as 2.30, which is obviously 2hrs and 30mins, but I need to show the result as 2.50 (2 1/2 hrs) because that cell will then be linked to an hourly rate of pay.

So, how can I change it so that the result shows as 2.5?

Any help would be greatly appreciated.

Cheers

Glenn

Ok I may have some difficulty in expressing this one, please bare with me....

We have team leaders starting at specified times (8 hr shifts):

I want to calculate total staff coverage over the teamleader 8 hr shift.

there are ptime shifts of 6hrs and fultime staff 8hr shifts

The most simple example would be:

Team leader starts at 0700 and has

3 f/t staff starting at 0700 = 3

2 staff starting at 1300 = 4hrs (1300-1500 x 2 will cross team leaders 0700 - 1500 shift))

2 pt staff starting at 1100 = 8hrs (11-1500 x 2 will cross team leaders 0700 - 1500 shift)

so total for this day would be 4.5 staff crossing his shift. Attached is a sample of how i have set up the spread sheet minus the formulas...

If you have a remote idea of what i am trying to express please check out and edit the spreadsheet at will :-)

This question is more about how to calculate than anything I guess - thanks guys...

Isabella

Can someone please advise how to calculate percentage using a aphabets?

What I mean is I want to know the percentage of the cell which says "completed" vs nothing in the cell.

I've attached the excel sheet.

Please advice.

I have some equation that gerenarted from the trendline in the chart (Power

equation). The other iteration want to use the formula directly from the

chart. Somehow I don't know how to do that since I can't find in the Help.

I'm basically trying to perform algebraic equations with excel.

Could someone give me a hand with this theoretical question:

A man, when asked by his niece how old he was, replied, "My age is now four

times yours, but five years ago it was five times yours." How old was he?

Name Credit Current

David 50 50

John -90 -90

John 40 -50

David 30 80

Tim 30 30

The problem is how to calculate the column "current", which is the sum of all the credits of that person at that time. Can anyone shed some light on this? Thanks.

How to calculate a pay-back period by the accumulated cash-flow

automatically? How to count number of negative values in a row range? How to

count ratio of a first positive value to module of the last negative value

automatically?

first monthly payment is $2,500 compounded annually by 3% -- I know

how to calculate what the payment will look like say in the 10th year

which is $40,317, with this formula :

P = future value

C = initial deposit

r = interest rate (expressed as a fraction: eg. 0.06)

n = # of times per year interest is compounded

t = number of years invested

>

> But I can't figure out how to calculate the total amount paid in the

> 10th year which is $425,761. I got the answer by building a

> table and summing the yearly payments as follows - but, I want a formula that will return the answer of $425,761 with the variables I have.

>

> $2,500 3% $30,000 $30,000

> $2,575 $30,900 $60,900

> $2,652 $31,827 $125,509

> $2,732 $32,782 $159,274

> $2,814 $33,765 $194,052

> $2,898 $34,778 $229,874

> $2,985 $35,822 $266,770

> $3,075 $36,896 $304,773

> $3,167 $38,003 $343,916

> $3,262 $39,143 $384,234

> $3,360 $40,317 $425,761

Thanks,

John

IE: Date in Cell(A1) 16/12/1993

Value in B(1)= 12 (Years)

should give date 16/12/2005

-------------------

TIA

Andrew

something, accross several worksheets.

No luck finding an answer? You could always try Google.