VBA Excel Help.

E

emmcee

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

Hey,
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

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
Excel Sumproduct 0
adding up event durations? 1
adding cells with text 1
Can I get date in this format? 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Populating data to right based upon cell criteria 1
month gaps counting through whole column 14

Top