timestamps

Hi folks, I'm sure i have done this before but can't remember how or find specifically what im looking for! Essentially 2 tabs 1. Data 2. Audit Whenever i change a date in a specific cell in tab 1, I want the Audit tab to create a new row recording the cell that changed and when it was...

I have this dynamic list of data in Power Query, I would like to ask if it is possible in power query to add a time stamp if the product become "Out of Stock". Below is a sample data. Can't do it on excel formula as the position of Product are moving to different rows Product Availability...

Hi, I maybe overlooking clues I can see on the internet but I am still having trouble converting date and time (day-month-year-mins, sample below) into unix timestamps. Would be most grateful for help please. Alfie101 <colgroup><col></colgroup><tbody> 20/4/2017 30 20/4/2017 32 20/4/2017 39...

Hi , i have a data set where my assignment is to create a graph which shows the number of timestamps for every hour during the day. The resolution so far is to create a column for every hour for a day(example shown)and formulas which validates whether the time is within the singular timestamp ...

Hey guys. I have the hardest time with getting formulas to work the way I want. I've got a list of timestamps in Column "C", and a list of dates in Column "N" (starting in row 5, 1/1/2018,1/2/2018 etc.). In column "O" I want to count how many timestamps from column C fall on the date from column...

Hi, I've currently got a load of timestamps in column J, generated by pressing a button. I wondered if anyone would be able to tell me how to get cell G10 to turn green if 3 or more of the timestamps are in the same day? Thanks!

Hi all, I have a table (tab= "(HIDDEN) Source Data") containing data in range C3:W2000 (though sometimes there are less than 2000 rows containing data - it varies). Columns L, N and O contain dates and timestamps. The data in the table is used in a couple of different pivot tables in the same...

Hi Guys, I run a vba code everyday to update my reports. I would like to add a few lines to the code so that I can publish the time when it was run. This will basically help others who have access to the file to know when the report were last updated. Any pointers? Thanks in advance. Cheers.

I am trying to query an external database where I only want to return the rows that fall between the hours of 11 AM and 3 PM. I can't for the life of me figure out how to set up the criteria in MS Query to bring back the rows that meet the 11 AM to 3 PM window. The column being queried is a...