I am trying to get values entered into a calculation I have set-up using
minute() and hour(). These functions allow only (as far as I can tell) a
value to be typed in and then used in the function. I want to have function
ready to recieve a value typed in from a cell. The user will type in value
and the calculation will use this value for answer.
Ex. of calculation:
=MINUTE("11:00")-MINUTE("13:36")*(-1)+((HOUR("11:00")-HOUR("13:36"))*(-1))*60
WE have a specific need for this. If the above isn't possible then how can
use a macro to get a value form a cell them plug it into this calculation?
Any help would be greatly appreciated. I hope this makes sense. Thanks