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!
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!
