date/time

Can someone help me understand why this VLOOKUP formula isn't working? I have worksheet 1 with raw data and there is a column of cells custom formatted m/d/yyyy h:mm:ss AM/PM. I have worksheet 2 (same file) that is using VLOOKUP to reference a unique segment id located on the same line of...

Hi I am working on a data sheet for users, the idea is to capture the current date & time by scanning an external laminated barcode, there are various activities happening in the room, and, as and when a particular activity is completed, the supervisor scans a barcode (the barcode remains the...

I have data the is in this format 10/1/2015 09:57:49 AM. I need to change it to be 01-OCT-2015 09:57:49 AM. When I try concatenate for the day I get some weird numbers back. Get the same when I try concatenating the time piece. Any help is greatly appreciated.

The field that I am trying to filter within is date/time in the following example format: 9/1/2015 10:00:00 AM I need to filter for "yesterday", which I know should be "date()-1", but for some reason this isn't working. It seems like the solution should be simple, but I'm having difficulties...

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...

In excel, I have reports that give me a column of dates (m/d/yy in Column A) and a column of times (hh:mm:ss in Column B). I have an issue with the dates being listed as the previous day if the time is before "07:00:00". To fix this issue, I normally run an IF statement in the "C" column that...

Gents, Please i need an advise ASAP i have been using this statement and it cant help if(and(c1>=a1:a144,c1<=b1:b144),"yes","no")) and it just works for the first 2 values c1, c2 and doesn't fit for the others. the case is i have more than one event at the same video and i need to confirm...

I'm fairly new to powerpivot but learning fast. (Thanks to this board and PowerPivotPro) I am preparing to do an analysis for my boss that will include several date/time calculations. (number of Invoices per day, week, month, average invoice amount per day, week, month, etc.) I am using Excel...

I have a spreadsheet that contains a column of date/time. In that column there are several entries for the same date. I am trying to count the number of 'same' days that occured in a month. Any suggestions at all????? :confused:

Hello, I've used this code before in a worksheet; it used to work fine, and now it's not working: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then Target.Offset(0,1) = Now End If End Sub It used to put a date/time stamp in column B whenever I altered...

I am trying to pull just the date out of a field for comparison's sake. I am capturing the time of an event using the NOW() function. This is driven by a drop-down menu that populates a start time and finish time field. It gives me the timestamp in mm/dd hh:mm format. I need to pull just the...