textbox time convert

[asyamonique]

Hello,
I did formatted the textboxes values like

TextBox9.Value = Format(Now(), "h:mm")
TextBox10.Value = Format(Now(), "h:mm")

And i'm trying to find the total minutes between eachother by manually changing the values...
My question is after 24:00 calculation gives me wrong figures with the below code. like if the times changed 23:30 - 01:30 = 1320min!
Is there any way to make it in different way?

TextBox8.Value = Format((Application.Max(TextBox9.Value, TextBox10.Value) - Application.Min(TextBox9.Value, TextBox10.Value)) * 1440, "0")

Thanks.

 

[mikerickson]

Try

TextBox8.Value = ABS(TimeValue(TextBox9.Text)-TimeValue(TestBox10.Text)) * 24 * 60

 

[asyamonique]

Run-time error '424':
Object required

Thanks

 

[mikerickson]

That's error is probably because I misspelt TextBox10.