Word VBA to find difference between two clock times and then also subtract additional minutes
I am trying to create a VBA routine in a word table that will subtract a start time from and end time to get hours & minutes, then subtract an additional amount of minutes from the total.
For example, table cell E3 (contains end time) minus cell C3 (contains start time), then from the result, minus cell D3 (contains the amount of minutes taken for lunch). End result would be total amount of time worked during that time span.
I want to put the result in cell F3. I would then repeat this on each of the ten days in question, and then at the bottom sum total all of the F column data.
I have it set up right now to manually type in the F column on each date, and the document automatically adds each item to the total as it is typed. But I am hoping to set it up so the document can calculate the F cells based on entering the C, D and E data, and then total that for me.
|