Thanks to wideboyDixon for his help on my last post about userforms.
I am looking to calculate the difference between 2 times (sometimes over a 24 hour period) - code below
again I have it sorted on a sheet that works fine but cannot figure out how to formulate it on a userform
the code below is what I use on a sheet, on the userform c9 would relate to textbox8 (stop time) and e9 relates to textbox11 (start time), I also have textbox9 for start date and textbox10 for end date, if these are required
Any help Appreciated![]()
=TEXT(E9,"00\:00")-TEXT(C9,"00\:00")+(C9>E9)
scouse13
Bookmarks