I have a form with an In and Out Time. I want the user to input the time with no colon and no AM or PM. Then a Calculate button will give the total hours. Is this possible and the am pm is not necessary but would be helpful. Attached is a sample form that does work when the time is entered in as 12:00:00 AM format. Thank you for any help.
Maybe try this
Private Sub CommandButton1_Click() If TimeOut - TimeIn < 1000 Then TotalHours = (Left((TimeOut - TimeIn), 1) & ":" & Right((TimeOut - TimeIn), 2)) Else TotalHours = (Left((TimeOut - TimeIn), 2) & ":" & Right((TimeOut - TimeIn), 2)) End If Range("A1") = TotalHours End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks