calculating time in vba

[dreamer]

I need help on this one.
I have an excel sheet where the user can enter a date (in column A)
and starting time (in column B). In column C they can enter how much
time a certain action will take. Column D to AA are hours ( 0 to 23).
The idea is to get something like this:
A B C D E....
16/03/2004 13:45 0:17
So after the data is enter I need to calculate how many minutes of the
time user entered falls in certain hour. For the above example it was
15 minutes in 13 hours en 2 minutes in 14 hours (13:45+00:17 = 14:02).
Now, the thing is that I need those calculations to take place in VBA,
not in excel worksheet and I could use some help..

 

[Frank Kabel]

Hi
the same question was answered some hours ago by JE (originator name:
'Nick'). check this post
Jus curious: Are you Nick???

 

[dreamer]

Yeah that was me. I asked it in google.groups but I have just figured
out that all those post also come here and vice versa. The only problem
is that it takes ages before google updates so I can read it only after
9 hours or something...