date & time

Hi, I need to convert EST to GMT time including day and date. For example A B C D E Date Day EST EST GMT Day GMT 01/11/2023 Wednesday 21:00 01:00 I would like this to show it would be Thursday. Column A and column C are manual inputs I have formulas in B and D that are working...

I'm trying to create a tracker that contains a column to check if we've met SLA. Column A - Date Received Column B - Time Received Column C - Date and Time Combined (A2+B2) Column D - Date Resolved Column E - Time Resolved Column F - Date and Time Resolved (D2+E2) Essentially, what I need to...

Hi, I have data like below. This is just a sample and the actual data is about 20k rows. The column with the date and time is unhelpful and I'd like 3 new columns (as per my desired result below), ideally formatted as Date, Time and Date and Time respectively. Hoping someone can help...

Hello! I am very new to this forum and I couldn't get the XL2BB extension to work so excuse the formatting since I just copied and pasted the data from my excel file. I have data that is recorded every hour every day from 1999-11-01 to 2023. I only pasted a small portion of the cells as it has...

I have an import from SQL that gives me a Run Date Time column. I am trying to return the latest (most recent) value, so I can see at a glance what it is. I have tried an INT(A2) or Max(A2:A14) and I am getting errors in return. Thanks in advance for your suggestions...

How can I have dates be on 8 Week rolling data but always start at a Monday? For instance this is what I did to get it to start from 8 weeks ago: But I would want it to actually start on 5/2/2022 because that was the Monday of that week.

Hello everyone, I am working on a project employee capacity-sheet, with several projects and the capacity for each month. I want the percentages (D2:M4) shifted automatically when I, let's say, change the end date to 2023-05. How do I achieve this? Thank you so much in advance! :-)...

So it's a little complicated what I need. Therefore bare with me :). I need to find a date which will be taken from a sheet called Raport. Cell where data validation of the date is "D4". I need that date to be searched in multiple sheets. Each sheet is showing like this...

ABCDEFGHIJKL1DAYDATADATE/TIME2DAY 1E2F2G2H2autofill date/time3E3F3G3H34DAY 2autofill date/time56DAY 3autofill date/time7 Hi, I have tried to post this previously but have yet to get this solved. I need Excel to automatically FILL-IN and UPDATE the current Date & Time in cell L2 (which is...

ABCDEFG1DAYDATADATE/TIME2DAY 1cell B2cell C2cell D2cell E2cell G23DAY 2auto-fill dd/ hh:mm:ss4DAY 3auto-fill dd/ hh:mm:ss5DAY 4auto-fill dd/ hh:mm:ss Hi, can anyone help me get this done? I need Excel to automatically FILL-IN and UPDATE the current Date & Time (dd/ hh:mm:ss) in cell G2...

Hi, Is there anything in Excel VBA that will identify the current date format of Excel? I am writing a macro and the people who will use it will be in the US and UK. I do not want to create two different solutions. Is there a way I can know what date format Excel is using so that I can base my...

Hi all. I have thousands of rows of interval data where the date/time column is written like this: 2020-10-26T00:00:00. I would like the data to read dd/mm/yyyy hh:mm:ss. I tried doing a custom date and time format as per my requirement but it wont convert it. The 'T' in the original data...

In the post at: https://www.mrexcel.com/board/threads/vba-advancedfiltering-faling-to-work-after-changing-the-format-of-cells.1192601/ I was looking for a way around getting advanced Filter to work for dates stored as texts in the format "dd-mm-yy". According to @Marc L, it is not a good idea to...

Hi, I have a really big table in Excel that has multiple rows where each row contains a comparison between two employees that had worked over the same time. See examples of some sample rows in the image below: My aim is to find out which employees had the highest income during the day but I...

Hi, I am trying to sort orders by date/time within the CSV export from my order system, however when I try to sort it does the dates correctly, but not the times (hour/minute). How can I make it so the sort works for the hour/minute as well? I tried changing the formatting to see if that would...

Hi, I have a spreadsheet that contains multiple entries each with a start and end time. I want to be able to identify overlapping time entries and then be able to group the overlapping entries by perhaps assigning a Overlap Group ID to pairs of overlapping entries. Start and End Times can be...

I have a set of dates say in column A and want to associate custom week numbers that reset after every 5 weeks. So for example, the week counting starts from 27/09/21 (Monday) and will end on 31/10/21 (Sunday) making it 5 weeks. For dates after 31st of October, I’d want to reset the week number...

I thought I was pretty good at managing Date formats in Excel but this one has left me stumped. The raw data field in the csv pre import is in the USA format and complicated by being AM/PM too. ,"8/30/2021 7:39:07 AM", ,"8/29/2021 11:28:40 PM", All other columns are simple numeric or text How...

Hello people way more skilled than this guy. I'm trying to create a bit of a call/issue tracker making it as simple as possible for those taking the calls to complete and get me useful data. I'm totally a google stealing machine and don't know much but when it works it works. So I found a...

I have a report that gives the time as "8/19/2021 12:26:01 AM -04:00", but I need the " -04:00" part to be taken off. Is there any way to custom format or integrate a formula within that custom format so this would be the case? I want to avoid altering the spreadsheet otherwise. My alternate...