date & time format

Hello, I am trying to convert about 75 000 lines of datetime formate data (YYYY/MM/DD HH:MM:SS) into just dates (YYYY/MM/DD). The only way I have found to do this it to concatenate the YEAR(), MONTH(), DAY() parts of the data in one column into another column. However, with so many rows, this...

Hello! In my office we use slack for the majority of our communication needs. With Slack you can build workflows that allow users to enter data which can then be imported into an excel sheet. Slack date/timestamps each submission in the excel file in a format which looks like this...

Dear all, I am looking for a vba code which can help me find a recent file uploaded in a path for example "D:\Test\" and copy the data from the file to current workbook open. The file name contains both the date and time of upload in its name. eg- "20210126_11_03_42_Test_2" and in the file name...

I have a MS Access application that is used in multiuser environment. I want to make maintanence every thursday between 15:00 and 16:00. At this point I have two issues to consider. Firstly, The users who may entered to application before 15:00. Secondly, the users who will be entering between...

Hi all, I have a problem, I set up a macro to format a column (fixed-width) with a date format DMY. It works fine on my PC but on a colleague's pc, it isn't working. Here the code Columns("A:A").Select Selection.TextToColumns Destination:=Range("A1"), DataType:=xlFixedWidth, _...

I Have a item " spoon " Price is €0.07 per day One customer who has ordered 50 spoons on 1.11.20 ( and still has not returned them). On the 7.11.20 he orders another 40 spoons. On the 14.11.20 another 20. On the 21.11.20 he returned 30 spoons ( I would charge him 21 days at € 0.07) On the...

I am trying to subtract a load of dates from an earlier date to end up with seconds which I can then do modular division on with the number of seconds in a sidereal day. This will give me time separation that I can sort to find similar location of points in the celestial sphere. I simply...

I need to create a mark book. =VLOOKUP(G3,'Yr5 Maths Aut'!$A$1:$U$112,MATCH(I3,'Yr5 Maths Aut'!$A$1:$U$1,0),0) The Vlookup table uses the following Ages 9 yrs 1 month, 9 yrs 2 months etc to 9 yrs 10 months. Total 9.00 9.10 9.20 ….. 9.90 9.10 9.11 10.00 10.1 The problem is...

Hi everyone, When I use the formula: ="The date is" & TEXT(M30, "dddd, mmmm yyyy") I encounter with this: The date is00, mmmm 2020 Although the M30 cell is in the date format, the formula did not work the way I wanted it to. I could not understand what happened? Any advice or suggestions very...

I’m dealing with the timestamps from Google form, which come in the following format.

Greetings all - I have a date format and pivot grouping issue, please: I've been given output in the format d/m/y 00:00. I believe this is standard Euro Area/Australian date format. This column, as given to me, is formatted as General. I have set my windows regional formatting to use Australia...

Using this: Private Sub Create_CSV() Dim content As String Dim Rng As Range Set Rng = Range("A12:AS30") Dim Path As String Dim FileName1 As String Dim FileName2 As String Dim FileName3 As String Dim sWB As Workbook, _ sWS As Worksheet Dim dWB As Workbook, _ dWS As...

Hi Guys, could you help me with formula to get date from text as below ? from text: 30.5.2019 19:24 to this date format: 30-05-2019 7:24:00 PM Thanks a lot.

Using a share file on Microsoft Teams Problem: I add data every day and my team use the data for reporting within the sharefile. Every day when we enter Teams and update the data, the dates we use revert to English (US) or Armenian. The date columns are formatted to dd/mm/yyyy using custom...

HI all, I hope someone can help. I have a Dtae&time column with 04-07-2019 15:17:10. I only need the date (preferably as 04.07.2019). I have tried to simply reformat the date to another format but that does not work. Any ideas? Thanks in advance.

Hi everyone, I am looking for create a gantt chart to track different stages of projects, I tried rearranging a template I found that had the week already in the template (the only one i could find). Each stage has a start and end date, and the date has to be entered in the wwyy format. The...

Hi everyone, i have a problem i cant solve myself and google havent helped me so far, its a 3 step question and i hope you guys can help me out! i have multiple sheets with a timeline with custom dates as a string (yyyymm). i need to change this string format to a date format and after that i...

Hello - I'm using O365 in the US but have system time on my PC set for Australia (in case this matters…) WorkSheet #1 I have received two excel worksheets, one has dates formatted in DMY, and if I switch the formatting of any of those cells to General, I see that the resulting number (in...

Hello All - I have been sent a worksheet with dates from a user in Australia. The date format is: 17/06/2016, so Day, Month, Year. And to be more specific, what I've been sent is: 17/06/2016 18:53, so D, M, Year and a time stamp. There are other dates that I need to merge and sort with these...

Hi, I have the below code which opens a word document and find words in column A and replaces it with the text in the adjacent cell in Column B. This works well. My issue is that when it copies a date from one of the cells to word, it displays the date as a number rather than a date. Public...