Time difference caliculation on a userform

HI all, am struggling to workout how to show the difference between a start time in textbox9 and an end time in textbox11 on a userform, users will enter the times hour and mins in these boxes and on exiting textbox11, I would like the result to show in textbox12

any code to help would be useful

scouse13

Originally Posted by Arkadi

Hi scouse13,

I don't know what you are doing to validate/restrict the values in the textboxes, but if it is guaranteed to be a time, and is in 24hr format, then this might work for you:

Please Login or Register  to view this content.

Thanks Arkadi, that works fine, but it does not work correctly if the time exceeds 24 hours, could I insert 2 more boxes for date entry and could the code be changed to take this into account

scouse13