Subtracting Dates/Times

[SKZag]

Hi,
I just started learning VBA in the last few weeks and I am really stock/lost. Please can you help. I am looking for a VBA code that can subtarct two dates/times….subtract columA from columB.....

ColumB is 27/06/2008 23:38:01
ColumA is 27/06/2008 23:35:10

if possible, how do I get the differece in minutes i.e. 3 min

Thank you for your help

[Paul]

Hi SKZag, welcome to the forum.

Adjust this code as needed to reference your cells:

Range("C1").Value = CInt((Range("B1").Value - Range("A1").Value) * 1440)

[antoka05]

'my previous post was erroneus... I apologize*

[SKZag]

Hi Paul,

Thank you for your reply.
Paul, I adjusted your code according to my needs, however I am still getting the following error “Runtime error “13” Type mismatch”.
Actually, the data changes from day to day and the formula is Qi = Pi - Oi
The code is below:
>>>
Dim NumberRows As Integer
Sub Subtract ()
Range("P1").Select
Selection.End(xlDown).Select
NumberRows = ActiveCell.Row

For i = NumberRows To 1 Step -1
Cells(i, 17).Value = CInt((Cells(i, 16).Value - Cells(i, 15).Value)*1440)
Next i
End Sub
>>>
Thank you very much for you help.

[shg]

Please read the Forum Rules and then edit your post to wrap your code with Code Tags.