1. A

    Convert date and time to unix timestamps

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

    Calculating hours between two timestamps

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

    COUNTIFS formula.

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

    Timestamp Day Count

    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!
  5. S

    VBA Timestamp from multiple named columns using VBA

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

    Timestamp at the end of a vba code

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

    MS Query and Time Part of Timestamp

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

Some videos you may like

This Week's Hot Topics