Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,570
- Office Version
- 365
- 2016
- Platform
- Windows
I am trying to get the # of hours between two time values.
I am using this line of code in my attempts to do so ...
Me.uf8g_apetime = "9:00 PM", and Me.uf8g_petime = "8:30 PM"
The result I get (Me.uf8g_e_minsdev) = 0.02. I am expecting 0.5 (1/2 hour)
Can anyone suggest how I must change my formula to get the desired result.
I am using this line of code in my attempts to do so ...
Code:
Me.uf8g_e_minsdev = format(TimeValue(Me.uf8g_apetime) - TimeValue(Me.uf8g_petime), "0.00")
Me.uf8g_apetime = "9:00 PM", and Me.uf8g_petime = "8:30 PM"
The result I get (Me.uf8g_e_minsdev) = 0.02. I am expecting 0.5 (1/2 hour)
Can anyone suggest how I must change my formula to get the desired result.