Get instant live expert help on I need help with excel timestamp to date
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
i need a way to connect data over a timestamp, example: 10 points have a different time in one list. and in another list there are 20 points for a timestamp. out of these 20, 2 points have to be added to a point in the first list, the rule is that the points timestamp has to be within half a second of the timestamp from the point on the first list
Solved by F. H. in 27 mins
Need to have values from one tab displayed on another tab based on timestamp
Solved by I. Q. in 27 mins
Problem signature: Problem Event Name: APPCRASH Application Name: EXCEL.EXE Application Version: 15.0.5093.1000 Application Timestamp: 5bed2d14 Fault Module Name: FM20.DLL Fault Module Version: 2.1.3425.0 Fault Module Timestamp: 327129d8 Exception Code: c0000005 Exception Offset: 00002b92 OS Version: 6.1.7601.2.1.0.16.7 Locale ID: 1033 Additional information about the problem: LCID: 1033 skulcid: 1033
Solved by M. H. in 12 mins
how to convert timestamp (example "Wed May 02 11:34:20 GMT 2018" to "yyyymmdd"
Solved by X. W. in 18 mins
How do I count the number of times something happens during a given time range? For example at the 9am, 10am, 11am, (during the entire hour) etc how many people purchased a book. Note the timestamp is inclusive of the date and time of day
Solved by I. F. in 27 mins