All Questions
6
questions
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 ...
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
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 ...
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 ...
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 ...
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 ...