All Questions
Tagged with timestamp microsoft-excel
18
questions
0
votes
1
answer
99
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
223
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....
- 1
1
vote
0
answers
32
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 ...
- 11
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 ...
1
vote
1
answer
519
views
Plotting Non-Contiguous Time Onto a Chart in Excel
I was given a spreadsheet with dates and timestamps of when one of our systems went down and came back up with the task of creating a visualization of the data. The Date and Timestamps were embedded ...
- 37
0
votes
2
answers
116
views
How to highlight trends in time records? (system errors)
I have a list of system error timestamps.
I want to graph the time from the timestamps to see if there are any trends -- i.e. approximate times of day when the system often goes down.
Question:
Is ...
- 157
1
vote
2
answers
1k
views
Excel won't recognize timestamp in format of "m/d/yyyy h:mm:ss AM/PM"
I have a column of timestamps (strings) formatted like so:
This can be deduced to the following format: m/d/yyyy h:mm:ss AM/PM
I'm trying to get them to be formatted into dates but Excel refuses for ...
- 115
0
votes
1
answer
980
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
0
votes
2
answers
443
views
converting numbers into timecode in Excel
I have a column with a bunch of two 4 digits.
1354 1356
1402 1421
1431 1452
1532 1546
... and so on
I've been trying to convert these to look more like
13:54 ~ 13:56
14:02 ~ 14:21
14:31 ~ 14:52
...
- 3
0
votes
1
answer
2k
views
How to group timestamp in the format yyyy-MM-dd'T'HH:mm:ssZZZZ into buckets of 15 minutes in excel?
I need to find the number of records (pid) in the interval (buckets) of 15 minutes for a year long data. Normally when MM/DD/YY H:MM AM, you just pivot the data, put timestamp into row, click on group ...
1
vote
1
answer
6k
views
Excel is changing my time input (32:00:00 becomes 8:00:00)
I am making a spreadsheet in Excel to keep track of time. When I enter 32:00:00 (hh:mm:ss) on the spreadsheet, it changes my time to 8:00:00. But when it adds up all the time at the bottom it still ...
- 13
1
vote
2
answers
275
views
Finding an Error in Formatting Based on Time in Excel
I have a column of times which span some twenty-four-hour-long interval (not necessarily starting at midnight or noon). The first one is filled in manually and then each subsequent one is autofilled ...
- 137
3
votes
5
answers
39k
views
Convert Timestamp 00:00:00.000 into total seconds AND milliseconds
I have the problem that I am left with a timestamp that reads like: 00:02:02.300 meaning: hours - minutes - seconds - milliseconds.
and need to desperately convert it to total seconds. That is tricky ...
- 51
0
votes
2
answers
6k
views
Format cell as minutes for use in time calculation?
I have 4 columns: Time In, Lunch, Time Out and Daily Total. The Daily Total column uses the following formula:
=([Time Out]-[Time In])-[Lunch]
I want to be able to simply enter minutes for the ...
- 1,923
3
votes
1
answer
2k
views
Excel 2010: Daylight Savings - calculate # of hours between timestamps for any given day
I have a checksheet which cross-checks various water measurement points, reading the average rates from around thirty different meters out of another system. I've automated this checksheet so a VBA ...
- 554