Problem With VBA Formula To Determine Difference Between Two Times

[Ark68]

I am trying to populate a userform textbox with the difference between two times found in two other textboxes of the same userform.

Textboxes cu2_start = "7:00 AM" and cu2_end = "15:00". I am looking to populate cu2_hours with "8.00".

I have this line of code

.cu2_hours.Value = format(DateDiff("h", .cu2_end.Value, .cu2_start.Value) / 60, "0.00")

It's giving me an answer of -.13. Clearly there is something wrong with my formula.

 

[Ark68]

The result of "8.00" (rather than 8) goes into a userform textbox (.cu2_hours). It's not a cell that needs to be formatted.

.cu2_hours.Value = format(DateDiff("n", stv2, jt) / 60, "general number")

doesn't seem to be cutting it.
We've gone full circle and we're back at the original question (post 1)

There was a typo in my code, but even fixed, still leaves the same result.
cu2etv should have been etv2.

etv2 = CDate(.cu2_end.Value)
jt = IIf(etv2 = 0, 1, etv2)

 

[yky]

Let's go back to #19 . You got 8 instead of 8.00, this can be fixed with string manipulation. What about others (.25, .50, .75)? Did you get them correctly?

If the only problem is whole numbers, then just append ".00" to them by string manipulation.