unix timestamp

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

    timestamp sorting

    hi, I am new to this group. I need to sort out my timestamp which is in human-readable format. The issue which needs to be sorted is following 1. firstly, I need to make this time format in DD:MM:YYYY hh:mm:ss 2.as you can see it has similar timestamp few of them, based on the total number of...
  3. D

    Convert Excel Date/Time *TO* Unix timestamp

    Hi all, I've searched a lot on Google and on here and have found a ton of ways to convert a Unix timestamp *TO* an Excel Date/Time value but I need to do it the other way. I've got 2 columns of values (about 9700 in total) - they're all in Excel Date/Time format and the cells have been...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top