Subtraction in VBA

[Sakumi]

Hello all,

I know there seems to be a lot threads on this topic already, but I can't find any of them helpful.

I have a column of time points (h:mm:ss) being continuously generated. I need to subtract a single starting time point from each of the time points in this column to get an elapsed time.

So as example, I have a column of data in A:A that is being continuously generated and I have a starting time in cell C2. I need something like A:A - C2 and put that data in another column, ex. H:H.

Can anyone help with the script? I am very new to VBA.

Any help will be greatly appreciated.

Sakumi

 

[pgc01]

Hi
Welcome to the board

Why do you want to use vba?
This is such a simple problem that you solve with a formula.