VBA Userform calculations on Times (Start time - Finish Time = Total Hrs)

**Kitsa** · 11-04-2020, 07:56 PM

I'm trying to build a userform to calculate times to work out employee timesheet on how many hrs they have done e.g. Start time 9:00am to 5:00pm = 8hrs but I'm unable to get this as it's not calculating the two "times". it gives me -96
Is anyone able to help me with my VBA?

Please Login or Register  to view this content.

Full Userform Code:

Please Login or Register  to view this content.

Capture.JPG

**torachan** · 11-05-2020, 04:09 AM

See the code in the userform attached.

**Pepe Le Mokko** · 11-05-2020, 04:12 AM

Any reason why you did not post in the VBA forum?

VBA Userform calculations on Times (Start time - Finish Time = Total Hrs)

LinkBack

Thread Tools

Rate This Thread

Display

VBA Userform calculations on Times (Start time - Finish Time = Total Hrs)

Re: VBA Userform calculations on Times (Start time - Finish Time = Total Hrs)

Re: VBA Userform calculations on Times (Start time - Finish Time = Total Hrs)

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to find the Earliest Start Time and Latest Finish Time during a period

[SOLVED] Conditionl Formating to highlight time slots between start and Finish time.

Calculate finish time given start time, working hours and job duration

Ready Time, Start Time, Finish Time by user

Utilising time in a drop down list to show start and finish time

calculate time start and finish times and deducts breaks

[SOLVED] template or formula for start time -finish time -total hours ple

Bookmarks

Bookmarks

Posting Permissions