Userform - Time input

  • Thread starter Thread starter Hennie Neuhoff
  • Start date Start date
H

Hennie Neuhoff

On a usefrorm the user must complete the time spent on various projects. The
input is formatted HH:MM. My problem is when the time is in excess of 24
hours, and the totalis more than 24 hours I can't get the correct nuber of
hours displayed.
Is there a way around this ?

Thanks in advance
 
Be sure you get the times in correctly. One way:

Sub marine()
Dim s As String
s = Application.InputBox(prompt:="enter time hh:mm:ss", Type:=2)
t = TimeValue(s)
MsgBox (t)
End Sub
 
On a usefrorm the user must complete the time spent on various projects. The
input is formatted HH:MM. My problem is when the time is in excess of 24
hours, and the totalis more than 24 hours I can't get the correct nuber of
hours displayed.
Is there a way around this ?

Thanks in advance
Click to expand...

Hi Hennie

Try [HH]:MM as format.

HTH,
Wouter
 
Where is it that you can't display the correct number of hours at? On a
worksheet? In a TextBox on the UserForm? Somewhere else?

Also, showing us the related code you have so far (working or not) would
help us to figure out exactly what you are attempting to do.
 
Back
Top