[Question] Calculating time difference of different/same dates

Hi everyone,


So while surfing the net, I came upon a VBA code:

Private Sub CommandButton1_Click()
ActiveCell.Value = Format(Now(), "dd-mmm-yy h:mmAM/PM")
End Sub

Basically, what this does it to input the current date and time on the active cell (which I use it as a 'push-button-macro').
Now, what I have a two timings of different/same date which I wanted to find a differences of e.g.

08/06/2006 04:33

12/06/2006 01:05

Time difference is 92:32 [hh:mm]

Credits to: http://www.excelforum.com/excel-form...ifference.html

I know that I can use the B1-A1 formula but, my start time/date cells are actually a bunch of cells merge together and if I were to follow the formula, I would get a #VALUE! even when I changed it into the time format...

Please help!

EDIT:
Example, one of my start time column would be cell ET67 to FR86 merged into one. So when I select the cell to imput the data, the current date and time would be inside the merged cell of ET67 to FR86. For some reason, I don't think that the B1-A1 formula is able to calculate merged cells...