Hi members.
My problem is as follows:
Column A from 00h00m to 07h00m, the value of column B is multiplied by 2.5.
Column A from 07h10m to 13h00m, the value of column B is multiplied by 3.5.
Can someone help me.
Thank you.
Hi members.
My problem is as follows:
Column A from 00h00m to 07h00m, the value of column B is multiplied by 2.5.
Column A from 07h10m to 13h00m, the value of column B is multiplied by 3.5.
Can someone help me.
Thank you.
You could do it with a formula in column C
Formula:Please Login or Register to view this content.
Last edited by AlphaFrog; 07-19-2021 at 06:27 AM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
@AlphaFrog:
Thank you.
Can someone use vba code for me?
Thank you.
Macro code
Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
@kvsrinivasamurthy
from 13h10m to 23h50 the results are not accurate.
Please review the code for me.
Thank you
Conditionsare given for 0 to 7 hrs and 7 to 13 hrs only . Rest there is no condition.
Code modified
Please Login or Register to view this content.
Last edited by kvsrinivasamurthy; 07-19-2021 at 11:20 AM.
@kvsrinivasamurthy
I edited the code
The result is exactly as expected.HTML Code:
Last edited by tax112; 07-19-2021 at 08:51 PM.
This gives the same result and is a lot faster when it comes to a lot of data.
Please Login or Register to view this content.
Messages have been translated from Dutch to English by means of google translate.
@Vraag en antwoord
Your code is short
Accurate results.
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks