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