All Questions
Tagged with microsoft-excel timestamp
18
questions
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
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
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 ...