VBA Excel Help.

Sep 6, 2011
Reaction score
VBA Excel help. Finding the duration in hours between two dates using VBA coding.?

Could anybody help me with this in excel there is a range of dates that start from 27-Aug-2011 08:36 till 28-Aug-2011 05:12.
And I am suppose to find the total time in hours. the instructions says that "Values in the Date/time cells are real numbers expressed in days. You can subtract them and scale them by 24 to get the duration in hours."
I'm suppose to write a Code in Microsoft VBA so that I can find the total time duration between the two dates but I don't know how to do it. Could anybody help please?????

Thanks in Advance! :)

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question