I am trying to find out the number of minutes that have gone by between two different times. The data given to me is presented like this:
[FONT="]
1st Date and Time (2 cells)
8/11/2018 06:48:36pm
2nd Date and Time (1 Cell)
08/11/18 06:43p
The dates are pretty much irrelevant as they are almost always going to be the same day. How can I format these cells so that I can then find the amount of time elapsed between the two in minutes?[/FONT]
[FONT="]
1st Date and Time (2 cells)
8/11/2018 06:48:36pm
2nd Date and Time (1 Cell)
08/11/18 06:43p
The dates are pretty much irrelevant as they are almost always going to be the same day. How can I format these cells so that I can then find the amount of time elapsed between the two in minutes?[/FONT]