=OM(B44<>0;0.5)+MAX(B44-3;0)*(3.5/47)
Den första delen
=OM(B44<>0;0.5)
Kollar om det står någonting i B44. Om det står något så blir det 0,5 timmar.
Sen Tar den det störst värdet av (B44-3) respektive 0. dvs om B44 är mindre än 3 så blir inget påslag. Om det är mer än tre timmar tar den
(B44-3)*(3.5/47)
Dvs 3,5 timmar (4-0,5) /47 kvm = timmar/kvadratmeter efter den första halvtimmen
Obs att resultatet är "decimaltimmar", inte timmar och minuter (dvs det näst högsta värdet är 3,99 timmar, inte 3:59)
Om du vill se svaret som timmar:minuter så får du ändra formeln
=(OM(B44<>0;0.5)+MAX(B44-3;0)*(3.5/47))/24
och sedan ändra visningsformatet för cellern till tid. Högerklicka och välj "Formatera celler". Eller tryck [Ctrl]+3
I en kurva blir det ungefär så här:
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAeAAAAEhCAYAAACnYHOEAAAc4UlEQVR4nO3db4wb953f8Y/kf5IvaiupVYQ5EYRy8NrXBk4TjSozRH17D6IHxoXCegscbwDlwfWRMPATdg2bZ6B9cgZxAI9P1oQeHBKgFjplga4XS+RB7QDN1tcNsdDorgenqXdyd8paylwq9yK1FrReR9H2wSy1opakOCsOZ4Z8vx6JQ87wp6+o/ezvN8Pv7PvZz362tbm5KQAAMBrPPPOMntzc3NTU1FTcYwEAYGJ4nqf9cQ8CAIBJRAADABADAhgAgBgQwAAAxIAABgAgBgQwAAAxIIABAIgBAQwAQAyejHsAvfjNsuYa68GDfEmObT74pMpzDalYVaVgDLxv32MCADBCyZwB+03NN06o5DhynJLyKwtq+jtPu4st5Yr5cPs+4pgAAIxSIgPYd1tScUbB/NTUTFFqudtp6dZV06w6J76u6palutt7377HBABgxBIZwL35ai5IpV1Lx6ZsxxErygCAtEhVAPvNebVy7VksAADpldiLsHbz5bbWtb4+J6vR3rYi69roLqa6cuWKDh06NJL3Ghf79u3T1tZW3MNIFWoWDvUKj5qF9+STT+orX/nKcI851KMNiWHmpLlFuQVbplwtNqRc1VSh4KjQfpFbV9mf2XUVdPd9DRnqvj2Mzz77TKdOnRrOX3JCeJ7H7S5DombhUK/wqFl4nucN/ZiJDGAZBc3mLdWsFUlStliV3TcrXdWtmlRyZJu99g17TAAAorNvbW1ti9+EBrO8vKzp6em4h5Eq/KYdHjULh3qFR812fHH3nr7/o1/oR//zlzprHtPZ08e6vm7YNfM8L6EzYAAAItQO3v/0X3+uX372hSTpr/76//YM4CgQwACAidEteNvyXz060rEQwACAsdcveI8fOaDzZzMjnf1KBDAAYMy996GfqOBtI4ABAGPp8sc3dXHpqq7d2OjYHnfwthHAAICxcu3Ghi4uXdXlj292bE9K8LYRwACAsXB7464ufXBN733YeaOdI4ee1vmzGf3eN4/HNLLuCGAAQKrd3rir9z70tfjnf6fbG3c7nnv1ZUPnz2b0pYPJi7vkjQgAgAH0C97TLxzWhXMnlTl2MKbRPRoBDABIlX7Bmzl2UBfOndTpFw7HNLrBEcAAgFToF7xJu8BqEAQwACDR2k00Ln1wbSyCt40ABgAkUhK7Vw0TAQwASJRxD942AhgAkAiTErxtBDAAIHZJ7dccJQIYABCbpPdrjhIBDAAYubT0a45SYgPYb5Y111gPHuRLcmxTkuTWLdVWgs3ZYlWVgrFr316v6XVMAMBopK1fc5SSGcB+U/ONEyo5FZlyVbcW1JwxVVBTq5mqHMeQ/KbKc4tyC7bMh/bt+ppex9yd3wCAIUtrv+Yo7Y97AN34bksqzmwHq6mZotRyfckoyH4wMbMZBY9c1S1LdVc9X9PzmACAyNzeuKt33/9E59++squRxukXDut7b3xDF86dnLjwlZI6A+5jZ3k5r5JjbwewKdtx+r6GqAWA0RmXfs1RSl0Am7Yjx1awvGyV5Vcru5aRu71mWGd7Pc8b0pEmBzULj5qFQ73Ci6pmdzbv6YcfbWj5x5/rzua9jueOHnpCr5x6Vi89f0DSp/K8TyMZQ1qkLoDvMwqazTe06kvqdR73gdcMK4CnpqaGdKTJ4HkeNQuJmoVDvcKLombj2q+5LYpfWBJ5Dtgwc1JjUa4kydViQ8qZhuTWg/O829tXV7LKPBy+PV7T85gAgD374u49vfehr/N/fEUXl652hO/xIwf0evE5XXrrVKrDNyrJnAEbBc3mLdWs4LtE2WJVtiHJOCNZlqztl+VLzvbys6u6VZNKjmyz12t6HBMAENqktY2Mwr61tbUtlm8Gs7y8rOnp6biHkSosD4ZHzcKhXuE9Ts0mNXiH/TnzPC+hM2AAQOJMYr/mKBHAAIC+Jrlfc5QIYABAV/RrjhYBDADoQL/m0SCAAQCS6Nc8alQSACZcv+A9/cJhXTh3UpljB2Ma3fgigAFgQtGvOV4EMABMmDub9/Tu+590DV4usBodAhgAJkS7ica//y83dWfz7zueI3hHjwAGgDE3qd2rko4ABoAxRfAmGwEMAGPmUcH7rRef0ne+/WJMo0MbAQwAY2SQfs1R3NsW4RHAADAG6NecPgQwAKQY/ZrTiwAGgBSiX3P6EcAAkCLXbmzoA/eGvv+jX3Q00Xj6yf169XcM/f7v/ib9mlOCfyUASLjbG3e1/Jf/Rx+4N/S/1j/b9Xz+q0d14dxJffnIMzGMDnuV2AD2m2XNNdaDB/mSHNuUJLl1S7WVYHO2WFWlYAy8b6/tAJBElz++qR+4n2rlo7/XF3fv7Xr+t37zN3Th3El97bf+YQyjw+NKZgD7Tc03TqjkVGTKVd1aUHPGVEFNrWaqchxD8psqzy3KLdgyB9y36/bd+Q0Asen3Hd623/36P9Hv/POjyn/16IhHh2FKZAD7bksqvrYdrKZmiguad30VCgXZhQdemM0oyE9XdasmlRzN+N33NdXrmCQwgPg9Knh/O3tIZ81jmv76P+Yc75hI3b/izhJ0XiXH3g5gU7bjSJL8ZnxjA4Cw+gXvkUNP6+y/OKaz5jHuxzuGUhfApu3IsRUsQVtl+dXKSJeR6SATHjULj5qFk8Z6/erXW/rvP/lcH/zlHf2/jc7zu0cPPaFXTj2rl54/IGlTG7euybs13PdPY83GTeoC+D6joNl8Q6u+pBEG8NTU1OjebAx4nkfNQqJm4aSxXoO0i4xSGmsWtyh+Ydk/9CMOgWHmpMaiXEmSq8WGlDMNya2r7rZf5Wp1JauMMdi+PY8JACNy+eOb+sM/+QtdXLraEb7HjxzQ68XndOmtU3SumiDJnAEbBc3mLdWs4PtG2WJVtiHJOCNZlqztl+VLzvby885FWLbZY1/12g4A0aJdJLrZt7a2tsVSxGCWl5c1PT0d9zBShaWu8KhZOEmuV1LbRSa5Zkk17Jp5npfQGTAApNjtjbt670Nfi3/+dx3tIiXp1ZcNnT+b4atEIIABYFj6Be/pFw7rwrmTfJ0I9xHAAPCY+gVv5thBXTh3UqdfOBzT6JBUBDAA7FG/4OUCKzwKAQwAIbW7V1364BrBiz0jgAFgQP3aRhK8CIsABoBHIHgRBQIYAHogeBElAhgAuoi7XzPGHwEMAA+4/PFNXVy6qms3Njq2E7wYNgIYAES/ZoweAQxgoiW1XzPGHwEMYCLRrxlx49MFYKLQrxlJQQADmAj0a0bSEMAAxhr9mpFUBDCAsUS/ZiQdAQxgrNC9CmmR2AD2m2XNNdaDB/mSHNuUJLl1S7WVYHO2WFWlYOzat9dreh0TQPoRvEibZAaw39R844RKTkWmXNWtBTVnTBXU1GqmKscxJL+p8tyi3IIt86F9u76m1zF35zeAFPnVr7doG4lU2h/3ALrx3ZZUnNkOVlMzRanl+pJRkN1OTMPQCV2X70uSq7plqe6q8zWSlM3I6HdMAKn13oe+/u1/+KUuLl3tCN/jRw7o9eJzuvTWKcIXiZXMGfAgfF/XsznNGJJkynac+0/tLEHnVXLsIIDjGSWACNCvGeMgpQHsqznfUu61irqtIJu2I8dWsARtleVXKxrW2V7P84Z0pMlBzcKjZt3971u/1n/+0W395FrnUvPRQ0/olVPP6qXnD0i6Jc+7Fc8AU4TPWPxSGcBufU6tXFWVR52/NQqazTe06mtoATw1NTWkI00Gz/OoWUjUbLedfs2fdmw/cuhpnf3a0/rXM1+LaWTpxGcsvCh+YUnkOWDDzEmNRbmSJFeLDSlnBgvJzbKlhUz3q5+Dl9eDc8Hb+66uZJUx+h0TQFLd3rird9//ROffvrLrZgmvvmzou298Xf/yn9E2EumUzBmwUdBs3lLNCr5LlC1WZRuS3EU11iWtz8lq6P5zlYKvulWTSo5s84xkWbK2D5UvOdtXOvc4JoDEoV8zJsG+tbW1LZYiBrO8vKzp6em4h5EqLHWFN8k120u/5kmu115Rs/CGXTPP8xI6AwYwUejXjEkUcQC7qlurOuPYQ7sICsD4oF8zJlnEAWzqTL6mVdeWSQID2EbbSGAEM+DVFWllxdJKx/agQQaZDEwWghfYEfkM2HYc2dG+CYCEI3iB3UZ2EZbvupJpdu1cBWB8caMEoLvIA3inL3NWxWpwR6PyvPRapUAYA2OMfs1Af9GfA75eVNUpyK+XgxsiGKZyWpQvEcDAGLp2Y0MXl67q8sc3O7YTvECniAPYUEYLcv0HZru+q5Yyei3aNwYwYjv9mjtbRh459LTOn83o9755PKaRAckUeQAXKrOqW5YakrRiqaGsitXudzECkD79mmi8+rKh82cz+tJBev4ADxvB/wquhAbGEf2agccTfSessq+Zjguu6I4FpNle+jUD2I11IQADoV8zMFyRBfDO14+klfa9A9vyJZakgZSgXzMQjcgC2LQdOXa3JWgAaUD3KiBa0beirET7DgCGi+AFRmMEtyOsPXQjBombMQDJQ/ACozXymzH4zbLmNfPI8PWbZc011oMH+ZIcO9jjwXPL2WJVlcLuxe1e+/baDkw6+jUDo7d/1G9oFF5TrrUot9+L/KbmGydUchw5Tkn5lQU1/WD7aqYqx3HkVItSo8tx+uzbdTswwS5/fFN/+Cd/oYtLVzvC9/iRA3q9+JwuvXWK8AUiMvIAlu+qtf6ol7SkYnuWbGqmKLVcXzIKstszXsPQCV2X70vBUrelutt7357HBCbQtRsb+qM/+4n+6M9+0nGzBIIXGJ1YzgHnS87jn//1fV3P5jRjSO2lbknym497YGB80a8ZSI6RnwMeDl/N+ZZyr9FTGhgE/ZqB5Enl/zi3PqdWrqpKDOnred7o3zTlqFl4w6rZnc17+uFHG1r+8ee6s3mv47l/mnla/+qbX9KX/9Gv5F/726G8X1z4jIVHzeIXfQC7dVm1XYvQfb+GZJg5aW5RbsGWKVeLDSlXNST5apa3w7fL1c/99jXU65jhTE1Nhd5nknmeR81CGkbNJqlfM5+x8KhZeFH8whL9OeDadRWrjnrkZXdGQbN5SzUrCO5ssSrbkOQuqrEuaX1O7e6WwVeRfNWtmlRyZJs99lWv7cD4oF8zkB7Rz4CzOZl7CLqgleWujXJ2bZQk4/5FWD337bMdSDv6NQPpE/lFWDO5suabZs8lYwB7R/cqIL0iX4JebKxrXTtLxgFaUQKPg+AF0i+lX0MCJhPBC4yPVH4NCZhE9GsGxgsBDCTc5Y9v6uLS1Y6WkRLBC6RdNAHs1mUtZFStGFrkdoTAnly7saGLS1d1+eObHdsJXmA8RBPApi1nO105BwyEc2fzni4uXaVfMzDmWIIGEqLdRGPhv93c1TaSfs3A+IluCXpX+8kHsQQNtPXrXnX6hcO6cO6kMscOxjQ6AFGJJoCNjLKS1vMlOTYxC3QzSf2aAewWUQAXVHEKwUzYqknKqlithOsHDYypR/Vr/taLT+k7334xptEBGJVoTyjd793sqm5ZsiSJWTEm1KD9mrlNHDAZRnRFx05HLLduybI4B4zJQfcqAN2MJoD9pspzDa1LUraoqlMQq9EYdwQvgH4iDWC/WdZcY13BOWBHFVIXE4DgBTCIaAK4PePNl+Q4LDRjctCvGcCgIgrga8Fy80pNVtevA3MOGOOFfs0AwoquFaVDA0qMP/o1A9irxPa12zl/rIe+uuSrWZ5TQ0VVK90v5nLrltqNuLLFqirbX0DufUwgnNsbd3Xpg2v0awawZ/vjHkBXflPzjRMqOY4cp6T8yoKavhR8n3hemi0q22ff1UxVjuPIqRalxqLcvscEBnd7467eff8TnX/7yq7wffVlQ9994+uEL4CBJDKAfbclFWe2zxGbmilKLddX8H3ibh21gkYfdVeSUZD94AuyGRl9jwk82oPB+3AjjdMvHNb33viGLpw7yc0SAAxsTH5aBI0+2naWoIOLvQxJRC32gn7NAKIyJgHcybQdObaCr0NZZfnVytCuuKZNYHhprNmdzXv64UcbWv7x57tuDXj00BN65dSzeun5A5I+led9OvT3T2PN4kS9wqNm8RvLAL7PKGg239Cqr6EF8NTU1JCONBk8z0tVzQbt1xyltNUsbtQrPGoWXhS/sCTyHLBh5nYunpKrxYaUMwdso+XWg3PB2/uurmSVMR7zmBh7X9y9p/c+9HX+j6/o4tLVjvA9fuSAXi8+p0tvneJrRQCGJpkzYKOg2byl2nYXj2yxKtuQgoutamr39pizGsqXHNlmsF0lR7Z5RmrfeUlSvuRsX7TV65iYZLSNBBCXfWtra1ssRQxmeXlZ09PTcQ8jVZK61JXk4E1qzZKKeoVHzcIbds08z0voDBiIEP2aASQBAYyJQb9mAElCAGPs0a8ZQBIRwBhb9GsGkGQEMMZOv+5Vr75s6PzZDC0jAcSOn0IYG/2C9/QLh3Xh3Elljh2MaXQA0IkARurRrxlAGhHASK1+wcsFVgCSjgBG6iShXzMAPC4CGKmR5O5VABAWAYzEI3gBjCMCGIlF8AIYZwQwEol+zQDGHQGMRKFfM4BJQQAjEejXDGDSEMCIFf2aAUwqAhixoF8zgEnHTziMFP2aASCQ2AD2m2XNNdaDB/mSHNtsP6NmeU4NFVWtFGSE2Lf3MRE1+jUDQKdkBrDf1HzjhEpORaZc1a0FNWdMFYzgz5lSUdmFkPuq1zFH+jebOHc27+nd9z+hXzMAPGR/3APoxndbUnFGwfzU1ExRarm+JFO2U+kSmq7qlqW623vf3sdEFG5v3NW773+if/cfb+7q2Xz8yAG9XnxOl946RfgCmFjJnAGHZsp2HEmS34x5KBOOOxQBwGDGJIBHx/O8uIeQSHc27+mHH21o+cef687mvY7njh56Qq+celYvPX9A0i153q14BpkifM7CoV7hUbP4EcAhTU1NxT2ERHnUjPdbLz6l73z7xZhGl06e5/E5C4F6hUfNwoviF5ZEngM2zJzUWJQrSXK12JBy5mBXS/Xa93GOid2+uHtP733o6/zbV/qe4w1mvQCAhyVzBmwUNJu3VLNWJEnZYlW2IQUXW9W0sv2yOauhfMmRbQbbVXJkm7327bUdYXCHIgAYjn1ra2tbLEUMZnl5WdPT03EPIxZ7DV6WusKjZuFQr/CoWXjDrpnneQmdASMxmPECQDQIYPTEPXkBIDoEMHbhnrwAED0CGPdxT14AGB0CGNyTFwBiQABPMO7JCwDx4afrBOKevAAQPwJ4gnBPXgBIDgJ4AnCHIgBIHgJ4jLWbaDzcq1kieAEgbgTwGKJ7FQAkHwE8RgheAEgPAngMELwAkD4EcMrRrxkA0okATin6NQNAuhHAKUO/ZgAYDwRwStCvGQDGCwGccPRrBoDxlNif3H6zrLnGevAgX5Jjm323P8itW6qtBH/OFquqFIyB900K+jUDwHhLZgD7Tc03TqjkVGTKVd1aUHPGVEE9thud+65mqnIcQ/KbKs8tyi3YMnsd0+g5iljQrxkAJsP+uAfQje+2pOKMgvmpqZmi1HL9ntslV3XLUt2VZBRkP5iq2YyMPsdMitsbd/Xu+5/o/NtXdrWOPH7kgF4vPqfvvfENwhcAxkQyZ8ChmbId5/6jnSXovEqOHQTwEN7lb27s03ffvqJf/PLzIRzt0biyGQDG15gEcCfTduTYCpagrbL8akXDONv7/f/xpG5vRh++Rw89oVdOPauXnj8g6ZY871bk7xklz/PiHkLqULNwqFd41Cx+YxnA9xkFzeYbWvU1lAC+vTmEg/QxjjNez/M0NTUV9zBShZqFQ73Co2bhRfELSyID2DBzUvviKblabEi5qiFD3bd3cOuqy1ZwgbOr1ZWsMjOSYQywbwg/+NP8Y/0dAQCTLZEBHMxcLdWs4LtE2WJVtiFJvba7qls1qeTINs9IliVr+1D5krN9pXOvfQEAGL19a2trWyxFDOZb/yYI7+NHDujSW6diHk06sNQVHjULh3qFR83CG3bNPM9L5teQAAAYdwQwAAAxIID34DcOPhH3EAAAKUcA7wE3PwAAPC4CGACAGBDAe/D0k5QNAPB4SJI9OHLo6biHAABIOQIYAIAYEMAAAMSAAN6Dw//gqbiHAABIOQJ4D556Yl/cQwAApBwBDABADAjgPaARBwDgcRHAe0AAAwAeFwEMAEAMCGAAAGJAAO/Bl488E/cQAAApl9iTmX6zrLnGevAgX5Jjm323D2tfAABGIZkzYL+p+cYJlRxHjlNSfmVBTb/P9mHtCwDAiCQygH23JRVnFMxPTc0UpZbr99wuuapbluruXvYNj5sxAAAeV2KXoMMxZTuOJMlvRv9u3I4QAPC4SBIAAGIwJjPg0bp8uaUvcSH0wHyfk+1hUbNwqFd41CycAwcODP2YiQxgw8xJc4tyC7ZMuVpsSLmqIUPdtw9r30f5wZ/mh/nXBABMsEQGsIyCZvOWataKJClbrMo2JKnXdld1qyaVHNlm2H0BABi9fWtra1tTU1NxjwMAgInheR4XYQEAEAcCGACAGBDAAADEgAAGACAGBDAAADEggAEAiAEBDABADJLZiCOBuJfwIHw1y3NqqKhqpaB2nxNq15tbt1QLesMoW6yqUgiqRs16o2Z74DdVnmtI1GsAQWOnlfbD7M7Ps6HXbG1tbQuP8POlrTf/4J2ty1tbW1tbl7fe+YM3t5Z+HvOYEme7LpeXtt58c2nrfnmoXW8/X9p6p12MB+tEzXqjZnty+Z03t5aW3tl6s1vtqNdDLm+98+DPsLYh12xtbW2LJegBDPNewuPLlO1UVHiovSe168MoyG4XzDB0Qtfl+9SsrwdrJknZTDAzoWa9uXXVNNvxf5N6hRdFzViCBpLA93U9m9MM/ckfaWcJOq+SYwcBHPOYkstXc0EqVUzJXY17MOmx3tCc1ZDUeZpj2JgBA7Hz1ZxvKffaznlz9GbajhzHkVPNaMEqq0n69uQ359XKtWdtGIwp29n+jDklnWjMR/YZYwYMxMytz6mVq6pC+oZjFDSbb2jVFwHTlS+3ta719TltT+Ykrci6VlI1E+e40sTUmXwtss8YM+ABGGZOaizKlaT2vYRNfloOgtr146tZtrSQ6VziomZ9uHXV3fsPtLqSVcagZt0ZKlTaMzlHTimvbLEqxzap16D8phYi/IwxAx5Ez/sTY0fnpftzVkP5vvdnhtxFNdYlPTBDCc43UbOezDOSZcnafpgvOdsXF1GzUPiZ1lPHV40U7WeM+wEDADBi3A8YAICYEMAAAMSAAAYAIAYEMAAAMSCAAQCIAQEMAEAMCGAAAGJAAAMAEAMCGACAGBDAAADEgAAGACAGBDAAADEggIGJFdwO8cHb+9W5wT0wMtyOEICCMK5J92+9BiBqBDAAufU5tXJVVcz2Y0sLmaoq22nsN8uauzYrx5bqZV+ZEw01ViQpr5JzRqvb94IO7mdMggODYAkamHArNUs1lTqC0zyT13rLVbAa7cttScWZ7XReb6iVqcpxHJXyK6pZC8pUHTnVotRYlNvtTQDsQgADEy5fLCq7stoZnOYZ5ddbcn1JvquWcjLv53Nes9thbWSyUn42WLY2TOWy1+VzDhkYCAEMTDqjoNeK11UrN7WTnabO5NfVcn35bkvKmWJhGRguAhiAjEJFpRMNze1cEi1zpii1FrXYknIm8QsMGwEMQJJk2iXlV2o7X0syTOW0opWO5WcAw7JvbW1ta2pqKu5xAAAwMTzPYwYMAEAcCGAAAGJAAAMAEAMCGACAGBDAAADEgAAGACAGBDAAADEggAEAiAEBDABADAhgAABiQAADABADAhgAgBgQwAAAxIAABgAgBgQwAAAxIIABAIgBAQwAQAwIYAAAYrDvpz/96da9e/fiHgcAABNj//79+v+fLIfR+uitEQAAAABJRU5ErkJggg==)
Obs att jag valde gränsen 3 kvm (du nämner både 3 och 4:a). Om du väljer 3,5 kvm så har det redan börjat stiga steglöst
OBS 2. Jag har inte lagt in någon spärr vid 50 kvm. Om du fylelr i 55 kvm så fortsätter tidan att stiga