Calculate hours more than 12:00 PM Excel VBA

[primasatria]

Dear all,

I have time in (TextBox1) with value 06:00 PM and time out (Textbox2) with value 01:00 AM.
And result in Textbox3.

How to calculate in Excel Userform?

If time in 06:00 AM and time out 05:00 PM, the result is correct 09:00

If time in 06:00 PM and time out 12:00 PM, the result is correct 06:00

But if time in 06:00 PM and time out 01:00 AM, the result is wrong 17:00, not 07:00

I need your kind assistance and helping hands.

Thank you,
Prima Indonesia

 

[Alex Blakenburg]

Test if your time out is less than your time in and if it is add 1 (=1 day) to your time out before subtracting your time in.

 

[felixstraube]

From 6:00 AM to 5:00 PM should be 11 hours, not 9
and from 6:00 PM to 12:00 PM it should be 18 hours, not 6.

Libro4
	C	D	E
1	In	Out	Out - In
2	6:00 PM	1:00 AM	7:00
3	6:00 AM	5:00 PM	11:00
4	6:00 PM	12:00 PM	18:00
Hoja1

Cell Formulas
Range	Formula
E2:E4	E2	=IF(D2<C2,D2+1-C2,D2-C2)

 

[Scott Huish]

In an Excel formula, you don't need all that: =MOD(D2-C2,1) will suffice.
But the op wants VBA.
What code do you have right now?

 

[felixstraube]

I wasn't proposing to use a formula I was showing him the correct results he should expect