How to either write the macro or manipulate the function
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 |
How to either write the macro or manipulate the function
If 11:00 is entered in A1
and 13:36 is entered in B1 (enter these directly in the cell - don't include double quotes) =MINUTE(A1)-MINUTE(B1)*(-1)+((HOUR(A1)-HOUR(B1))*(-1))*60 should return an equal answer. (it gives me 156) -- Regards, Tom Ogilvy "Beth" wrote in message ... 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))*6 0 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 |
All times are GMT +1. The time now is 05:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com