asyamonique
Well-known Member
- Joined
- Jan 29, 2008
- Messages
- 1,286
- Office Version
- 2013
- Platform
- Windows
Hello,
I did formatted the textboxes values like
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?
Thanks.
I did formatted the textboxes values like
Code:
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?
Code:
TextBox8.Value = Format((Application.Max(TextBox9.Value, TextBox10.Value) - Application.Min(TextBox9.Value, TextBox10.Value)) * 1440, "0")
Last edited: