hi I would like a formula that will allow a user to input a figure (hours and minutes) into a cell that will calculate the end date and time based on a start date and time. For example, Enter 30 hours, static start time is 01/01/04 00:00hrs, the formula would then calculate that the end figure is 02/01/04 06:00hrs. Essentially it is calculating the number of hours & mins added onto the start date with the end result a date and time later than the hours & mins entered Hope this makes sense! Hi in A1 put your date in B1 enter your hours in the format hh:mm C1: =A1+B1 and forma...

I use Outlook 2002 ... this just started happening & I do not know what to do to resolve. Any assistance would be appreciated. In Date Navigator portion of Calendar, January 4, 2007 is bolded even though I have no appointments on that day? How can I get this date unbolded? Thank you - EJS ...

Hello! Does anyone know how you can calculate worked hours in a day on the basis of a start and end time? =(end_time-start_time)*24 -- HTH Bob Phillips "Aline" <A_Mangelschots@hotmail.com> wrote in message news:1127724380.330877.175210@o13g2000cwo.googlegroups.com... > Hello! > > Does anyone know how you can calculate worked hours in a day on the > basis of a start and end time? > Hi Aline With start time in column A, and end time in column B, enter in C1 =MOD((B1-A1),1) will give the time interval, even allowing for time period where the start is on...

Hi everyone. Please check this: On the POS put the Discount (Shift-F3) to 100% for the whole transaction. Enter an item that requests the Price entry at the POS. Enter a price. Watch the Tax at the bottom of the screen. You get a receipt with a Total of 0,00 including a tax of what the regular tax would be if the item wouldn't have a 100% discount. Isn't that a bit weird? Chris try updating to 1.3.1011 and see if its fixed. "Christian Olsen" <ChristianOlsen@discussions.microsoft.com> wrote in message news:14D63EDA-C3B9-46F2-8720-75CA2725D429@microsoft.com... &g...

Hi friends, I have a problem, in a macro I need to calculate a date adding working days only. This add not include saturday / sundays and holidays. For example: 21/5 + 6 days = 31/5 How i can to do ? Thanks in advance and sorry by my english, Christian For adding days, use the DateAdd function. It won't return an invalid date like 31/5. The Weekday function returns the number of the day, for instance this Weekday("22.05.2010" ,vbUseSystemDayOfWeek) returns 6 for Saturday, tomorrow it will return 7 for Sunday. For holidays I can't help...

Hi all, I badly need your help in the below formula Example: Structure : Account includes Sub-accounts and each sub-account includes dials Formula : Account activation date = Oldest Sub-account activation date where there is more than one account and hence different activation date for each account and in turn the sub-accounts that belong to each account Below the example A B C D Account # Sub-Account # Account Sub-account activation activation ...

Hi, I have a ntext field in a service indenity . When it is edited i want automaticly insert date en time. Can anyone help? Kind regards Maarten Kievit You may review this website on using Javascript to get time. http://www.tizag.com/javascriptT/javascriptdate.php In your onChange event for that field, you may add var currentTime =3D new Date() var month =3D currentTime.getMonth() + 1 var day =3D currentTime.getDate() var year =3D currentTime.getFullYear() crmForm.all.[Your Field].DataValue =3D month + "/" + day + "/" + year; hope this helps. Darren Liu, Microso...

I have an XL spreadsheet that contains multiple columns, one of which contains data in date & time format. Is there a way to export this data and associated information from the record to another application, for example Word, and create a calendar? Any suggestions how to manipulate this XL data are welcomed. Thanks! ...

-- jsanders Data>text to column, go to step three and select date and YMD and for future posts it's considered rude just using the subject line Regards, Peo Sjoblom With the value 20010129 in cell A1, enter this formula in B1: =DATEVALUE(MID(A1,5,2)&"/"&RIGHT(A1,2)&"/"&LEFT(A1,4)) and the format the cell as a date. The various functions parse the 20010129 string into its components, and the DATEVALUE converts that string to a datevalue that Excel can recognize. ...

Hi I use a paper form at work that asks 3 multiple choice questions. The answer to each question is given a score, and the total score is then used to calculate whether risk is low, medium, high or very high. What I'd like to do is set this up in Excel 2002 so that the user simply clicks to select their choice for each question, and the score then results in the assessed risk level being printed on screen. Can anyone please either give me an outline of how to do this, or point me to where I can find a sample that I could modify. My email address as shown in newsgroups is fictitious. B...

I would like to filter on todays date. What is the field name for the current date. Thanks. Harry Try "Current Date." - Andrew Lavinsky Blog: http://blogs.catapultsystems.com/epm > I would like to filter on todays date. What is the field name for the > current date. Thanks. > > Harry > ...

I have a weekly timetable table for school terms with the following fields WeekID (automatic number), WkbeginDate (date), WkNo ( number 1 or 2). The WkNo can be either 1 or 2 . How can I get the Wkno field to automatically update with the correct week number for each new record ie if a record has week value 2 the next record will have a WkNo value of 1? I would prefer to do this using a query rather than a form. The timetable is not for the whole year and has 'holiday' breaks, sometimes restarting on a week 2, sometimes on a week 1. Hope this makes sense! Hilarys =?Utf-8?B?SGls...

in cells D & E i have a series of dates. I want to put a formular E - D = calculated number of days and i also dont want it calculating weekend? the purpose of this is excel to work out how many days it takes to serve a document is this possible and if so what is the formular please =NETWORKDAYS(Start_date,End_date,holidays) Holidays would be a range containing the dates of public holidays you wish to de excluded from your calculation. for example in your case, if you entered the range of holiday dates in cells H1:H10 =NETWORKDAYS(D1,E1,H1:H10) -- Regards Roger Govier "jenn...

I'm trying to use Excel like a "time clock" to check in/out of work. I want to be able to write the time in a certain cell that I came into work, left for lunch, came back from lunch, and left for the day. I then want to add up the hours for the week and any hours up to 45 I need to multiply by a dollar amount. Also, any hours above 45 I need to calculate for overtime. I can add the ours to get a total for the week but am having a hard time with multiplying "Time" by a dollar ammount. (Nevermind that I have to find the amount of hours overtime) Attached is a very s...

Is there a way to subtract 15000 minutes from todays date and show the results in date format. A1 = todays date b1= #minutes c1= A1-b1 (the date that many minutes ago) =A1-(B1/(24*60)) Format as Date -- Kind Regards, Niek Otten Microsoft MVP - Excel "J. T. SYLVESTER SR." <sylvester1501@peoplepc.com> wrote in message news:663e99ad.0410011045.29cd532b@posting.google.com... > Is there a way to subtract 15000 minutes from todays date and show the > results in date format. > A1 = todays date > b1= #minutes > c1= A1-b1 (the date that many minutes ago) Su...

I am trying to do a rather complicated validation (I think it i anyway!) I want to allow ONLY dates of a particular format to be entered int the one cell - i.e. YYYY OR mm/YYYY OR dd/mm/YYYY For example, the same cell can have either one of these format entered, but MUST match one of them to be accepted. 1970 is OK and is captured in the cell as 1970 (not 1/01/1970) 70 is assumed to mean 1970 on entry 05/1970 is OK, captured in the cell as 05/1970 (not 1/05/1970) 5/70 or May-70 is assumed to mean 05/0970 on entry 05/06/2004 is OK 5/6/04 or 5 June 04 is assumed to mean 05/06/2004 on entr...

Hi, I'm having trouble trying to hide every other label along a horizontal date axis. I start on the 01-Jan up to 10-Jan and through using the 'Format Axis'->'Scale'->'Major Unit' and setting this to 2 I can hide the labels: '02-Jan'; '04-Jan'; etc. However, I want to hide the odd dates: '01-Jan'; '03-Jan'; etc. I have tried the various combinations with the dialog box but can't get anything to work. Should I be using a custom formula or something? Any help is much appreciated. Paul. In article <1168177092.892944...

Can anyone help me with a little problem? Im sure you can I have a row of cells with percentages in so looks something like this 189% 140% 130% 120% 116% etc etc. Any way what I want to acheive is in the colum next to this I woul like a formula that would say if the value in the percentage colum wa between 200%-175% then it would be 30p. Or if its between 174.99%-150 then it will be 25p. Working its way down to zero. Can this be done in Excel? As I dont know where to start I have trie a few formulas myself and got a response of complete mash : -- Message posted from http://www...

First, thanks to the replies to my previous post. How can I work out the day & month when I only know the Year and Day Number? Ie Year = 2004 day number = 302 The answer I'm looking for is 28/10/2004 Again, taking into consideration the leap years Thanks again in advance =DATE(2004,1,302) Regards, Peo Sjoblom "Anthony Slater" wrote: > First, thanks to the replies to my previous post. > > How can I work out the day & month when I only know the Year and Day Number? > > Ie > > Year = 2004 > day number = 302 > > The answer I'...

Does anyone know where windows Xp gets the time and date it displays from? My system date and time often fails, resulting in the time beiing 5-5mn delayed compared to what it shoul have been . I wonder what can cause that???? ...

sometimes when I enter decimal fractions Excel thinks this is a date. How do I stop this? Hi Insert a single quote before the fraction '3/4 The quote will not show up in the cell, but it will tell Excel to treat the cell as Text. Alternatively, Format>Cells>Number>Fractions 3/4 will display as 3/4 but will be stored as 0.75 and can be used in further calculations. -- Regards Roger Govier "aa" <A@aa.com> wrote in message news:efV2MhV9GHA.4376@TK2MSFTNGP03.phx.gbl... > sometimes when I enter decimal fractions Excel thinks this is a date. > How do ...

"j.marie" <j.marie@discussions.microsoft.com> wrote in message news:9C223E6B-0C7C-46AA-BEAE-2B49F97D4949@microsoft.com... > Nothing. PLEASE write your question in the body of the post, not in the subject line. This is not a chatroom. Thankyou. In answer to your question, you would be better advised to buy an inexpensive dedicated accounting package. That will do what you want "out of the box". ...

I am trying to remove the auto generated time of 00:00 to every date in my chart. I have tried setting the format, but it just ignores whatever I try to input. Any help would be appreciated. Where does this appear? Which labels? - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ NeoFax wrote: > I am trying to remove the auto generated time of 00:00 to every date > in my chart. I have tried setting the format, but it just ignores > whatever I try to input. Any help would be appreciated. ...

I would like to have a date cell that can have an input mask of __/__/__ so that a user need only enter the numerics of a given date; i.e 052405. I I tried setting the cell format to custom mm/dd/yy and I get a return date of 10/1/43 !!!!!???? Why has excel lost the correct date? Regions global show the correct year range, and Excel is set to 1900 time? What do I need to do to correct this? Thanks XL's parse engine and display engine are separate - the displayed format has nothing to do with how the entry is parsed (other than Text entries are not parsed at all). For a workaro...

Hello- I need to get a quick calulation to help me sovle a problem. I need to issue a $50.00 credit, but need to take a tax rate into account. I need to know the calculation if the $50.00 final credit amount is in A1, and the tax rate is in A2, what calculation would be in cell A3 that would show the pretax price? This is pretty straightforward algebra: f = p * (1 + r) So A3: = A1 / (1 + A2) In article <2dd290b7-5b71-470a-9af0-8cd45678f20a@j35g2000yqh.googlegroups.com>, Sabosis <scott.sabo@henryschein.com> wrote: > Hello- > > I need to get a quick calul...