I have time data that I am parsing out of a serial number in an excel spreadsheet. Therefore, my data is in rows. I want to calculate the time between time stamps to calculate a cycle time. I am not very strong in SQL, is there a way to do it in the query builder in Access? Is there an efficient way to do it in Excel?
Well, you could easily do it in Excel if it's just calculating the different in time between the record in Row 1 and Row 2. If you subtract two date/time values, the result is the number of DAYS between them. Multiply that by 24 and you get hours. Multiply that by 60 and you get minutes.
In Access, it's a lot more difficult, but still possible. Since the data isn't stored the same way, you have to look up the previous date/time value in the table and then you can perform the calculations. I cover this in a couple of my full courses, but I have a TechHelp video coming out on this subject in the near future.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
