TextBox Time format and calculate tot. minutes.

[asyamonique]

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

Hello,
I like to put another textbox and when I change the times manually that textbox will show me total minutes.Is it possible to make it with a code?

If TextBox9 = 13:14
If TextBox10 = 14:24

TextBox11 =70

Many Thanks

 

[steve the fish]

Try:

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

 

[asyamonique]

Thanks