date & time

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

So I have a list if things in a sheet. In the A column there are names, B column has a date, C column has a number and the D column has another date which is 5 days from the date in column B. I want to be able to come up with something that when someone's name is written into column A and if the...

Hello, I have the below formula which work to determine the date a case was closed, but the issue is when using Now(), is always updates to the current date. =IF(OR([@Status]="Closed: Call complete",[@Status]="Closed: No Call"), NOW(),"") For instance someone changed the case status to closed...

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

Hello everybody, I want to create a conditional formatting for the following column in my stock portfolio: I would like 2 conditional formatting (i have two of these sheets, which are identical, so one for each): 1) I would like the first formula to highlight the cells if the date entered...

Hello, I have a table that I want some people to fill in. The last column is called "Submission date" and I want this to be automatically calculate. Trigger: When they (start to)complete a row in the table Rule for calculation: If that persons input is before the established cutover date -...

Hi! can you please help me on how to get the elapse days/hours/mins between two dates/time, excluding holidays and Saturday from 4:01am until Monday 04:59pm ? Work shift: starts : 5:00 pm ends : 04:00 am Thanks in advance :)

Hi, I'm making a stock investment tracker where all you have to do is enter in the transaction and it gives you all the your positions, whether they are open or closed etc. I was finally able to figure out a way to find my average cost per share after buying/selling/rebuying. I have a column...

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

I am having trouble adding a ‘Last Update’ cell to my worksheet. The things I have tried are: First, Used the VS editor and created a module, (Alt-F11): Function ModDate() ModDate = Format(FileDateTime(“MyFileName.xlsm”)) ‘With and without the quote marks’ End Function Then called the...

Hello Excel Warriors I am working and trying but failed to achieve the goal. I want to create an VBA program to create Excel sheet to calculate arrear of pay. I just want to create list of months automatically between start and end dates in which if the starting date or the end date have only...

Hi, I've worked all weekend to learn VBA. I came close, but code is probably what a proper coder would call (very) ugly. I would really appreciate tips on how to make a more streamlined code in addition to the key question: A rather big set of data are collected on sheet 1 ("Disorderly"). Column...

Good morning all, I have a workbook that tracks current in progress and completed jobs for the month. I'd like two cells, C2 & D2, to update upon every save with date (C2) and time (D2), so everyone that has access can easily see when the workbook was updated. Any help is greatly appreciated!

I'm trying to exclude duration of a date range from a set of range that is in another sheet: Table_1 shows total time in seconds a ticket was assigned to someone Table_2 shows the time in seconds when the ticket was put on hold Table_1 ID Start_Date End_Date...

Hi there, I am currently trying to create a dynamic calendar in excel. A disclaimer upfront: my username checks out. This is literally my second day working with excel formulas. I have done some VBA in Word before but that's it. So my idea is to mark certain cells in my calendar in color...

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. In column A (A1:A600) I have dates and time in format dd.mm.yyyy - hh:mm (ex. 04.10.2019 - 20:00 , there is one space between dd.mm.yyyy and '-' and one space between '-' and hh:mm). All those cells in column A are text cells. I need formula to convert those "dates" into weekday name...

Hello. In cell B1 I have current date created with formula =today() eg. 26-Sep-2019. In the same column starting from cell B3 (B3:B600) I have dates and time in format dd.mm.yyyy - hh:mm (example. 20.09.2019 - 21:00). All those cells (B3:B600) are text cells. In column A there are...