subtracting time between two cells vba

[lordriel]

I'm attempting to subtract a time in, say c9 from a time in c10 and get the difference in minutes, in vba.

I know this is a simple answer...Ji just don't know what it is.

Clearly I will need to know if the times are inverted (i.e. c10 time is earlier than c9 time), but that's also simple and I do know that answer.

Both cell output is hh:mm; I just need the difference between the two times, in minutes.

 

[DanteAmor]

The hours in Excel are given in relation to a day, so multiply by 24 hours, which is a day, and then by 60 minutes, which is an hour. That way you will get the difference in minutes:

Dante Amor
	A	B	C	D	E
1
8
9			10:55:00 a. m.		Minutes
10			08:55:00 a. m.		120
Hoja6

Cell Formulas
Range	Formula
E10	E10	=(C9-C10)*24*60

 

[lordriel]

Thank you for the quick response. But how do I code that in vba? I've tried what I thought would work. Then what I imagined would work. Then what I knew wouldn't work. No success.

 

[DanteAmor]

The result in cell E10:

Sub dif()
  Range("E10").Value = (Range("C9").Value - Range("C10").Value) * 24 * 60
End Sub

 

[lordriel]

a tad of tweaking (I'm using variables and some other junk not worth detailing) and it's good to go!

Thank you!