timestamp to date

Hi Introducing myself, my skill in Microsoft excel is very basic. So my coding skill is minimum. I am creating a simple system to track collection Tin time In and Out. Below are the concept. The tin number is fixed and is converted into barcode. When I press on the Time Out button, and scan...

Hi. I occasionaly download a .csv file which contains exactly one year of 1-minute interval data, held in 8 columns (A to H) and copy the data that I do not already have into a Master .xlsx file. The csv data looks like this: <tbody> A B C D E F G H 1 Timestamp Z1 Z2 Out Flo EnC Enp OpMo...

Hi All, This is driving me nuts. I have a report which I have exported from a webpage into excel format. I want to equate a timestamp (10/15/2015 8:36:16 AM) to a Work Week number. Would usually do this by =WEEKNUM(A1,2). However getting the #VALUE error. So figured the timestamp must be in...

Okay, so the data I'm looking at exports in this format "10/1/2013 9:25:00 AM", which I need to convert to "10/1/13", or something similar, stripping out the time element. The obvious answer, format cells/date is not helpful, as I need to manipulate the exported data in a pivot table, which...