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