Hello,
I have a userform for a time and motion and I just want to get the total number of hours thru vba code.
How can I convert the below formula to vba code?
Ex:
G2 = 1/16/2014 17:58
H2 = 1/16/2014 18:01
In I3, there's a formula: =B2-A2.
Also, Column I is formatted in Time ( 00:00:00 )
So it will result I3 = 0:02:57
I just want to convert the above formula to vba.
I've attached the file.
Thanks a lot!
Bookmarks