All Questions
Tagged with microsoft-excel timestamp
18
questions
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
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
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
5k
views
In Excel 2010, how can I subtract two times when I also have the date in the cell and get the value in seconds?
I have a column of data as follows:
09/22/2015 10:25:22
09/22/2015 10:27:00
I want to subtract 09/22/2015 10:27:00 from 09/22/2015 10:25:22 to get the value of 98 seconds.
I tried formatting ...
1
vote
2
answers
276
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
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 ...
- 11
1
vote
1
answer
524
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
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
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 ...
- 967
0
votes
2
answers
447
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
2
answers
123
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
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,943
0
votes
1
answer
4k
views
How to fix timestamp issue in Excel Graph?
I am working on making a scatter plot in Excel of some temperature data. I have
column A containing the date data as mm/dd/yy.
column B containing the time data as hh:mm:ss AM/PM
and the rest of the ...
- 141
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....
- 1