Getting the Number of Hours (or portions of) between two Times

[Ark68]

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_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.

 

[Tetra201]

Maybe

Me.uf8g_e_minsdev = Format((TimeValue(Me.uf8g_apetime) - TimeValue(Me.uf8g_petime)) [COLOR=#ff0000]* 24[/COLOR], "0.00")

 

[Ark68]

Hello tetra, thank you so much for your help.
I made a change based on your suggestion ...

Me.uf8g_e_minsdev = format(TimeValue(Me.uf8g_apetime) - TimeValue(Me.uf8g_petime) * 24, "0.00")

But I'm getting unexpected results with it to.
Me.uf8g_apetime = "9:00 PM", and Me.uf8g_petime = "8:30 PM"

The result I get (Me.uf8g_e_minsdev) = -19.63. I am expecting 0.5 (1/2 hour).
It's a bit off.

 

[Tetra201]

That's what you did: A - B * 24
That's what I suggested: (A - B) * 24

 

[Ark68]

Ahhhh ... I see! Works like a charm. Thanks!

 

[Tetra201]

You are welcome.