calculate time difference

hello

I need a vba macro which can calculate the difference between 2 hours

the problem is that I have the date in column A and the hour hh:mm:ss in column c

so I need the difference between every 2rows but calculating the date too

for exemple if I have

12 march 2013 11:55:00 PM

13 march 01:00:00 AM that the macro turns 65 mins

I need a macro and not a formula because ever difference gonna be used after that to compare other things

I read that datediff exist but it works only for hours or date and hour if they are in the same cell and that is not my case



thank u

Hi nancy3822

Please check attached file.
I'm not sure, if this is, what you are looking for and probably the code isn't perfect (maybe someone better experienced guys can code it better way), but I hope you'll find it somehow helpful.

Originally Posted by Sbarro79

Hi nancy3822

Please check attached file.
I'm not sure, if this is, what you are looking for and probably the code isn't perfect (maybe someone better experienced guys can code it better way), but I hope you'll find it somehow helpful.

Thank u sbarro

It is exactly what I need. I was trying to do it very long time thaaaaaanksssssss