date and time

Hello, I need help delete the time out of a cell that has a date. For example the cell shows "3/22/2012 12:00:01PM" but I only want to see "3/22/2012" I have over 10,000 rows so is there a formula that will allow me to delete the date out? Thank you so much!

I want the date and time to automatically populate when I enter something into cell C5 I want the Date to auto update in C6 and the time to auto update in C7 as soon as i enter something into C5 Is there a formula for this?

Trying to figure out issue with adding date and time. The code is listed below. I have watched the code while running. The initial date FDateS and FDate(t) value is m/dd/yyyy (9/16/2010) and no time. FDateS has different amounts of time added to it. The issue I have encountered is that once...

Hi Guys, I have a date column and a time column with values in them. I want to add the two together to produce a date AND time column. I don't care if its formatted as a number. When I try it the 'easy' (and clearly wrong) way, I get an error. What I'm doing is: Expr1: [date]+[time] What...

I'm trying to graph a vlookup column where the non-values are coded with NA() so that they do not plot. When I add the data series to the graph if plots properly; however, it skews the x axis (a date/time combo format) and will not let me set date/time before a certain value (e.g. the x axis...

Hello, I'm having trouble with excel 2007 plotting my maximum date/time on the x axis properly. I have set the maximum value as 40155.08333 (12/8/09 02:00); however, the maximum value keeps plotting as about 40155.2 (12/8/09 04:45 ish). I am thoroughly stumped. Ancillary information: The x...

Looking to automate daily worksheets by having the date/time columns automatically fill in based on drop downs for Month and Year and while the Day is retrieved from sheet names (numbers 01 through 31). Although I think I have the date part working, I am trying to get the hour as well. When...

Anyone know any creative methods so you could enter '25' into a date field on a form and have it return a value of '5/25/2010'? How can I defeat the Date/Time input validation message or get it to act like a text field? Thanks in advance Christian

Hello, I have a spreadsheet that i collaborate with multiple users on my office network. column A is for date, B for order number, C for Tracking number. I was wondering if there is a way where i can put the order numbers on daily basis and automatically show the time and date i made the entry...

I need a formula to put in B4 that will take the date in A4 and add the proper amount of days based on what the Start Date (will change frequently) is. So, in this example the correct date that should appear in B4 is 6/10/09. I have a couple more examples below. <TABLE style="WIDTH: 133pt...

Hi I have a date in cell: C2: 03/22/2010 I want to copy and paste to the last row. Normally I would do this but with autofill it changes the value. Please help! Range("C2").Select Selection.Copy Range("C2").AutoFill Destination:=Range("C2:C" & LR)

Hello all, I am sad to say I'm at wits end on this one. I automate my spreadsheets as much as possible and this one seems simple yet keeps escaping me. I have two sheets, Sheet1 has a date range and the Sheet2 has a header that needs to display the range of dates from the first sheet (ie...

Hi Excelperts, I have a column of data with time and date (format: 11/27/2009 12:42:40 PM) with hundreds of rows. I would like to highlight all the cells which fall with in the condition of Monday to Friday and 9:00am to 4:00pm, excluding public holidays. I am bit familiar using conditional...

I have an spreadsheet that is monitoring the productivity of agents, as well as the time that it takes to complete each task. My workforce keeps time as .50 = 30 minutes. So 7 and half hours is actually 7.5. Agents are putting the actual time of it took such as 15 minutes however I would like to...

I have a date column with thousands of lines (obtained from some external source) in the following format:- mm/dd/yyyy hh:mm (e.g. 07/20/2009 18:30). When I opened the file, anything with day >12 gets classified as text rather than date, anything with day <13 gets misinterpreted with the month...

I have a spreadsheet with dates in Col A and numbers in Col B. I want to sum all the numbers that are more recent than one year ago from today. I get the general structure of the SumIf, and I can get it to work if I enter a specific date, for example: SumIf(A:A, ">03Aug2008", B:B). But if it...

I want to count the number of occurences involving 3 columns of a spreadsheet, but one of the columns is a date/time field, and I only want to analyse the date. Example: A B C John 1 02/07/2009 09:45:10 Peter 1 03/06/2009 10:14:12 Fred 1...

I have a workbook that can be opened by different users at the same time. My goal is to ID each time it is being opened so it can be saved by that ID. What I am thinking is to date, time and user stamp the workbook everytime it is being opened. And because it needs to be unique, a database...

hello im trying to figure out how to do something so simple but so difficult my mind cant figure out how to do it.. ok here i go i want to be able to stamp a cell with a date and time if i could but i only want it to be changed when the list of people i have change the worksheet. but after...

What is the best way to convert the following collumn into a date format such as 1-2009 (Month-Year): 200901 200807 200808 200809 200810 200811