Time calculation formula to VBA

Hi All,

I have a worksheet that I am changing over to a Userform. On my worksheet is a time calculation formula. =Round(Mod(B31-B30,1)*24,0)/24 I would like to derive the same calculation through some VBA code but have been failing. On the userform, "tbstart" textbox is analogous to B30 on the old worksheet. "tbend" textbox is analogous to B31. "tbtotal" is my target textbox for the calculation. The time calculations occasionally go past midnight. I am just looking for total hours, rounded to the nearest hour.


Thank you,

Patrick