Yes.
Column A: Time (i.e 7:15) <-- make sure the number format is in time. I like HH:mm, but its up to you.
Column B: Time (i.e 15:10) <-- make sure the number format is in time. I like HH:mm, but its up to you. If you use H:mm, then make sure you get the am & pm correct.
Column C: =($B1-$A1)*1440 <-- takes the later time and subtracts the earlier time. This gives a value in days. multiply by 24 to get hours or multiply by 1440 to get minutes.

---

Remember - It's important to be comfortable in your own skin... because it turns out society frowns on wearing other people's

Are they just times or dates included?

Just times. The times are always am. And I need the duration in minutes. For the most part, it's pretty close to 1440 minutes which is 24 hours. I'm dropping off air sample test kits and picking them up a day later and I need the duration that they were set out to the exact minute.

---

I miss YaHey

He wanted minutes so have to multiple by 1440

Are they ever picked up more than 24 hours after being set?

if you are crossing into the next day, make sure you include the date in the number format. (i.e. 2017/06/24 11:13:00 AM)

---

Remember - It's important to be comfortable in your own skin... because it turns out society frowns on wearing other people's

They might be 25 or 26 hours but never more than that

---

I miss YaHey

Okay give me a few since you need an if statement to deal with that

=If(a2-b2>0,((a2-b2)*1440),((b2-a2)*1440+1440))

I had to type on phone but should work

Thanks I'll try that on my laptop when I get home, I've been doing all this on the phone too while I'm driving. I know shame on me.

---

I miss YaHey

Didn't work. Using 10:28 for set time and 8:45 for pickup time it gave me 103.

However, I modified it to this:
=IF(F3-G3>0,(1440-((F3-G3)*1440)),((G3-F3)*1440+1440))
(the real columns were F and G) and it gave me 1337 which is correct.


Thanks again you got me most of the way there.

---

I miss YaHey

You don't need an IF() statement, its an unnecessary step.

if dropoff time is in B1 and pickup time is in C1, all you need is

=(C1-B1)*1440+1440

if the time is less than 24 hours, then C1-B1 will be negative.

---

Swimming Workout of the Day:

Favourite Swim Sets:

2020 National Masters Champion - M50-54 - 50m Butterfly

If he doesn't care the sign

huh?

the total number of minutes elapsed will always be positive, since 1440 minutes is added to the result.

---

Swimming Workout of the Day:

Favourite Swim Sets:

2020 National Masters Champion - M50-54 - 50m Butterfly

My brain might not be working, i had a long day