Formulas using Time Stamp Data in Excel

[talenjay]

Hello everyone Hoping to get some help with time stamp data. I need to be able to calculate some aspects of time data that i have.
To start with, i am looking to find a formula to calculate the time between transactions. So in other words, time between an End Time and a new Start Time and presented in hours/Minutes (00:00).
Here is a sample of data that i am looking at in a table form.
So calculate the time between "End Time" (9:00) and new "Start Time" (9:01). Then, 9:12 and 9:12, then 9:25 and 9:27 etc
Yes this is simplistic math in nature, however i have several thousand lines of data to work with.

Please Login or Register  to view this content.

Any help is greatly appreciated!
Thank you!!

Talenjay

[6StringJazzer]

Welcome to the Forum talenjay!

Times can be added and subtracted just like other numbers. Starting in row 3, use

=A3-B2

and copy down.

BTW some of your example data is not correct. For example, it shows 9:29 to 9:58 as 0:59 but it's actually 0:29

[ChemistB]

If you will be recording times between days (i.e. overnight), then this formula will work better
In C4

Please Login or Register  to view this content.

[talenjay]

Thank you 6String, however i did try that but i think because the field contain 'AM' ans 'PM' i get a #VALUE! error when i try the simplistic formula =A3-B2.

[talenjay]

Thank you ChemistB
I have tried this formula, but when i copy down, all other results are 0. What have i done wrong?
Attachment 664308

[6StringJazzer]

This suggests that your times are actually text strings, and not times at all. The best solution is to use actual Excel time values instead of text. I suggest you attach your actual file. See the yellow banner at the top of the page.

The second best solution is

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.