All Questions
Tagged with microsoft-excel timestamp
6
questions with no upvoted or accepted answers
1
vote
0
answers
33
views
Auto Timsetamp formula is extending but not calculating correct/Today's date
=IF([@Code1]<>"",IF([@[Auto DT]]<>"",[@[Auto DT]],NOW()),"")
This formula to get timestamp in column [Auto DT].
Currently
Step1 = I add code in new row. New ...
1
vote
0
answers
349
views
Is the Excel "Last Modified" time adjusted to my timezone?
I'm looking at a Last Modified time stamp in an Excel Workbook:
I got the spreadsheet from China, and I'm sitting in Denmark. These two countries are in two different time zones, and I would thus ...
0
votes
1
answer
108
views
Excel - how to handle custom timestamp format
I have some measurement data from a datalogging software, saved as CSV, and one column contains time stamps like this:
12.04.2024 15:11:32:684
12.04.2024 15:11:35:752
The format of this is:
dd.mm....
0
votes
1
answer
228
views
Excel: the first and last time per day
I have an Excel file with timestamps and I want to find the first and last time per day,
My spreadsheet has thousands of rows, but here is an extract:
Startup Time
Shutdown Time
29.10.2020 15:59
29....
0
votes
1
answer
138
views
Auto Update Date & Timestamp in a specific cell irrespective of any data range (With or Without VBA)?
Would anyone be able to help me with this issue?
I have data based on the categories (as per spent) in specific columns & cells, i.e.,
C4:C25, F4:F25, I4:I10.
However, I want the "Updated ...
0
votes
1
answer
989
views
How do I convert strange timestamp into date format in excel?
I have this strange timestamp in an Excel spreadsheet, e.g.
2020-09-07 00:00:00.0
This is UK, so it's YYYY-MM-DD
How can I get Excel 2013 to see this as 07/09/2020 DD/MM/YYYY?
Thanks