I have a data file that has timestamps with irregular timing intervals and I need to chart this data.
But I want elapsed time in the X axis not absloute time.
How can I use thease to get an elpased time in hours?
When I try to do any math on the timestamp the results always come out wrong, not the wrong format, the wrong answer.
I have attached a file with the timestamps I am intrested in.
It all looks correct to me. The numbers look like perfectly reasonable "fractions of a day" (how Excel stores time numbers). I selected column B and formatted as elapsed hours "[h]:mm:ss".
I would have used something like =A3-$A$2 (note the mix of relative and absolute references) instead of the formula you have, but the result should be the same.
If you need help understanding how Excel stores date/time numbers: http://www.cpearson.com/Excel/datetime.htm
If you need to review number format codes (including those for date/time numbers): https://support.office.com/en-us/art...7-9c9354dd99f5
Originally Posted by shg
I found the answer on another forum:
Maybe I was not clear enough, but I need elapsed time in hours from the timestamps.
With timestamps in column A and elapsed time in column B
Elapsed Time (in hours) B1 =(((A3-A2)*86400)/3600)+B0
Last edited by AlphaBob; 09-24-2018 at 06:08 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks