Inmates can apply for pre-release when they have half their minimum sentence served. For example 2 years 6 months. They would have to serve 1 year 3 months.
I use this formula
Where A1 is half the years, B5 is half the months, and B6 is half the days. The problem is when an inmate is sentenced to a minimum of 3 years and 3 months. The latter formula will not calculate 1.5 years or 1.5 months. It rounds up. What I would like to do is covert the 1.5 years to months and the 1.5 months to days.
I need is a formula that averages totals from different months out of the year. I already have a yearly average. That was easy. But what I need is a 3 & 6 month average.
I also need it to be most current, so when I am in September, it will take the 3 previous months and average them and same with the 6 month. Then when I move into October, it would take its 3 previous months, i.e. - July,August, September.
I'm having an issue converting months into weeks. My example is I have people who must provide leaving notice (could be months or weeks). For instance column B details months, and column C details weeks. I'd like to convert months (column B) into weeks in column D, but am not sure of the components of such a formula so I won't list or guess as I'm just not sure.
I know that if I enter =3/4 in a cell it will give me .75 but is there is formula to convert fractions into decimals or is this the best way to do it? I was also wondering if there is some way to convert the decimal amount to a fraction
for measurement conversions I know that =B3*25.4 will convert a decimal to mm and so will the formula =CONVERT(E4,"in","mm")
and to convert mm to a decimal a few formula that work are =CONVERT(H3,"mm","in") =MROUND(H4/25.4, 1/8) =H5/25.4 =INT(H6/25.39999918*8)/8
But is there a way to convert a fraction to the decimal and is there a way to convert mm to a fraction instead of the decimal equivalent of the fraction? or maybe a formula to convert mm to inches but instead of the result being in decimal format it would be in fraction format?
I am creating a budget spreadsheet. I am trying to create a list box where I choose what month I want to start with and the other months follow in each column, depending on what month picked in my list box.
Someone will enter their financial year end in the worksheet e.g. 31/03/2014 and I then have 12 cells below it called Month 1, Month 2 etc up to Month 12. I need the cell next to Month 1 to calculate what it would be... so for a Year End of 31/03/2014 month 1 would be April and this needs to apply to the 12 months.
I need to be able to add up times worked for 12 months of the year. For example if one workd 49 hours and 23 minutes the month of Jan and the same for Feb, how do I do this and keep a running sum of them? I can't see to figure out how to format it so that it does not change to time of day since it will be over 24 hours.
I have just finished sorting my anniversary list by Month (in alpha order)
B C D E F 1 Hire Date MonthDay YearLast Name First Name 2 04/04/2011April 042011Emp 1 3 04/09/1996April 091996Emp 2 4 08/02/2012August022012Emp 3 5 08/09/2004August092004Emp 4 6 08/13/2001August132001Emp 5 7 08/16/2010August162010Emp 6
Is there a way to sort by Calendar year? Jan, Feb, Mar, etc.
I have a "start date" and an "end date". Is there any way to tell how many months are included in 2007 from those two dates using a formula? For instance, from 01-Feb-04 to 01-Feb-07, there is 1 month in 2007 (January). And likewise, 01-Jan-05 to 01-Jan-08 there is 12 months in 2007.
As noted, I have the start and end dates. I don't have the "how many months in 2007".
Start Date End Date How many months in 2007 01-Feb-0401-Feb-07 1 01-Jan-0301-Jan-06 0 01-Apr-0401-Apr-07 3 01-Feb-0301-Feb-06 0 01-Mar-0401-Mar-07 2 01-Feb-0401-Feb-07 1 01-Dec-0401-Dec-07 11 01-Jan-05 01-Jan-08 12
I want to compress my months into seasons. To make things easy I'm going to make winter, jan feb and march etc. i have a column with the months and next to it i have numbers. i need to add the numbers into one season. also i need the months in the left to be differentiated by year so fall 2006 is different from fall 2007
Looking for a formula to compare current year values to previous year values. For example, if the current year has values for the month of January through March (100, 100 and 150), current year value will be 350 and the previous year value will be 975 (i.e. 300+275+400). The aim here is to make the previous year months summation equal to the present (or current) values. As new values are entered for the current year, the previous year's values will have to change to reflect the new month's value entered for the current year.
Month 2012 2013 Jan 300 100 Feb 275 100 Mar 400 150 April 650 May 454 June 800 July 500 Aug 375 Sep 525 Oct. 300 Nov 410 Dec 510
Sample file is attached : Comparison_Years.2011.xls
Is it possible to format cells to convert a date format of month/day/year to = year/week #/day of week? For example, 04/05/07 (April 5, 2007) would read as 7145, (7=last digit of year/ 14 = week number / 5 = day of week....Sunday being the first day of week)
I came up with a formula that i thought should work but apparently not so could someone be kind enough to post a formula that will take the date in one cell and place it in another but showing 6 months later.
I have a excel file which deals with accounting systems. It has the Loan date in Cell B6 and Number of dues in cell B7. I need the column from B11 : B34 to be filled with due dates for every month. Suppose if the loan date is 12/05/2013 and number of dues is 10 then in B11 I should get 12/06/2013 , B12 it should be 12/07/2013 and B13 should be 12/08/2013 and so on based on the number of dues.
It's a formula I'm looking for. The best way to describe it is an example.
I have some numerical data on a sheet from cells A2 to A80. This data represents the amount of days each person has spent on holiday. The data will be shown on a graph, but instead of the graph having "1", "2", "3", "4", along the bottom, I'd like it to have "1 week", "2 weeks", "3 weeks", "1 months", "2 months", "3 months".
I -suspect- the formula will involve the " countif" function (or an equivalent) (eg. if the number is less than or equal to 7, add 1 to the "1 week" box, etc.)