convert hours into minutes

[princess12]

Hi everyone,


so i am trying to convert hours into minutes in textbox, and it not working

here is what i tried

Me.textbox1= Format(me.txthours, "h") * 60 + Format(me.txthours, "n")


Me.textbox1= (Hour(Me.txthours) * 60) + Minute(Me.me.txthours)

please guide me the right way

[ranman256]

The txtHours is not already in hours....what is it? A date/time?
is it an integer of hours?

[princess12]

it calculated from a listbox column a total but in time format hh:nn

this works if i put it in control source but i need the code in vba so all my formulas work apart from this one

[CJ_London]

you can't multiply text values, you need to convert them to a number first

try
Me.textbox1= val(Format(me.txthours, "h")) * 60 + val(Format(me.txthours, "n"))

[princess12]

sorry for the trouble, i just moved this line Me.textbox1= (Hour(Me.txthours) * 60) + Minute(Me.me.txthours) after listbox calculation, it was before, that why it didnt work. thanks a lot.

[June7]

Ajax, actually Access/VBA will do math on text values if it can recognize the values as numeric. There can be issue with addition because + character is also valid for concatenation (holdover from ancient BASIC). If both values are text, will concatenate.