date & time

Hi, I'm trying to create a formula in a table column that sums values based on a date/time range as long as the time difference between any values within the range and the value in the current row is roughly less than 2 minutes. The issue I'm running into is a spill error from said calculation...

Hi, I have a data like this (with many dates and outputs, here is just a simplified example): I want to plot a line chart showing all outputs with one single x-axis (CommonDate: 02/01/2024 - 02/21/2024). however, coming up with CommonDate row based on the date1/date2/date3/,,, etc is...

Hello All, I am trying to create an excel with start dates and response date to a ticket, in first row I am getting correct answer but in the second row I was expecting 61.58 but instead I am getting 13.58. Can you please help in explaining why this is the case. I've provided the formula I used...

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