duration

Hey mate....please help me i have to calculate duration for 2 date and time. Please help me with the formula on C. For example <tbody> A B C 1 Start End Duration 2 1 Jan 16 13:30 3 Apr 17 23:45 1 Year 3 Month 2 Days 10 Hours 15 Minutes 3 1 Apr 15 12:40 1 May 17 13:45 2...

Hi All, I was hoping someone can help me with a Gantt chart I've made. I want the dates at the top to be from the dates the project is starting to finishing. However, they don't match my start date columns and then when I plot the remaining duration date it doesn't correlate to the project...

Hi all DURATION function : Returns the Macauley duration for an assumed par value of $100. Duration is defined as the weighted average of the present value of the cash flows and is used as a measure of a bond price's response to changes in yield. DURATION(settlement, maturity, coupon, yld...

Hi -- I hope this is is a simple ask what's the best way to calculate the difference b/w two dates (in # of months) with the result rounded to the nearest hals month. So the difference between 4/15/2017 and 6/30/2017 would be 1.5 (instead of 2) Thanks!

Hi I'm trying to calculate the End Date Time knowing the Duration (in hours:minutes decimal unit) and following a specific schedule. Example: Monday: Start work at 7:30 until 9:00 Monday: --Break-- Monday: Start work at 9:15 until 12:00 Monday: --Lunch-- Monday: Start work at 12:30...

Hello. First-time posting so please forgive any breaches of etiquette. I have been using excel for over 20 years and rarely come across something that stumps me, but I have a real quandry on my hands and am very much in need of your collective wisdom. I am analyzing the distribution of...

Hello all! Stuck on a problem. I have a spreadsheet which contains information about when a website outage occurred. Each row is an outage incident. I can calculate the total duration of the outage. I have a "start of outage" and a "end of outage" timestamp, format 3/10/16 16:30:00. With the...

Good evening I wanna calculate the duration of an activity using excel 2007, the activity starts on 2/1/2010 and finishes on 9/1/2010 where Friday is a weekend , 7/1/2010 and 19/1/2010 are holidays.Hint duration equation = (finish-start)+1 Best Regards

Hello All, I am new to Excel, and working on a project timeline. I am trying to insert a number of days in column "b" for the amount of time each job will take. In column "c" I have the start date, and in column "d" i have the end date. I would like it to work so that when I enter the days...

Hi, I've been trying to figure out the differences between two date / time fields. I've tried a couple of options and I thought I nailed it by doing a =TEXT(D2-C2,"d h:mm:s") <colgroup><col><col><col><col></colgroup><tbody> Conversation ID Date Post Published Date Post Received 7 5:03:52...

Hi everyone, so I have a table (See end of the message) that lists the movements of my pallets in the warehouse. As you can see 1 pallet goes from 1 Location to another. I want to be able to calculate the difference of time between 2 locations. In this case I want to calculate the difference...

Hello, I am trying to calculate modified duration for an instrument that uses the day count convention BUS/252. BUS refers to the number of business days in the country (Brazil in my case - 246 BUS in 2015). How could I adjust the MDURATION function in Excel for this different day count...

I have been given the following task by my employer and am in need of some major help. I am trying to create a spreadsheet where I am given 20 different projects with various start dates, project duration's and cost and am being asked to allocate the cost of each job, per month, with the...

Hi there, I currently sitting in office stumbling over myself trying to put a formula in this report for my boss. Im guessing the deal was, he couldn't figure it out so has thrown the grenade my way. I could really do with some credit by fixing this for him so any help you beautiful people...

Hey guys, I've been trying to compute the mduration and duration function in excel. However, we are not allowed to use MDURATION or DURATION according to the lecturer. We have input variables: face value, coupon %, maturity(years), current price, yield.When any of those variables change, our...

Hi all, Is there a way to calculate the duration of uneven cash flows? I realize the duration function will do the trick on a regular bond, but I need something else. The XIRR function is extremely helpful for this when it comes to yields, but I couldn't find a similar function for duration...

Hi, I went through a few examples from this website and others about converting duration (not time!) into decimals. I'm using Excel for mac version 2011 I start with a new spreadsheet. in Cell A1, I enter 38:59:00 in cell A2, I want to see 38.98 (I'm not interested in the seconds) The 1st...

I'm interested in calculating in room time (this is for an operating room) between 5 pm and 7 pm. We're trying to figure out how often we use 12 ORs between these two time. Currently I have a column with "in room time" and "out of room time" . I want to know how many minutes a patient was in the...

Good afternoon, I am trying to get the average time it takes for employees to be ready/available for their shift, with a separate column showing the duration (minutes and seconds) since some people understand that better. However, anything over 20 minutes before or after the shift begin time...

Hi All, I am currently working on an adherence project & am a little stuck on a formula for the following Column B holds codes ie, Break Column E holds in duration in that code The formula needs to check column B to check its Break, then if duration is over 00:15:00 to count anything over...