Hi,
<colgroup><col><col><col><col span="2"><col><col span="2"><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>i have a table like above,
i need, using a macro, to count and then sum the total amount used for all non working days and calls outside working hours (7.00 am to 7.00 pm / 0700 to 1900)
using an excel formula i was thinking of using the D formula on the date and then count only the ones that have a value equal to 6 or 7.
But i'm quite new to vba and i have no idea how to right a vb code to solve this.
Month | GSM number | Extension | Group name | Subgroup name | Name GSM number | User ref1 | User Ref2 | Call date | Call time | Call duration | Destination | Zone/Country/Operator | Tariff | Type | Supplementary services | Indicative tariff | Usage amount |
Jan-13 | 0470/132056 | Unfiled - Niet toegekend - Non attribué | 19-Dec-12 | 10:51:51 | 00:00:42 | 31624298877 | Vodafone P-B | Normal | Outgoing roaming calls | R | 0 | 0.203 | |||||
Jan-13 | 0470/132056 | Unfiled - Niet toegekend - Non attribué | 29-Dec-12 | 13:10:45 | 00:00:45 | 31624298877 | Vodafone P-B | Réduit | Outgoing roaming calls | R | 0 | 0.2175 | |||||
Jan-13 | 0470/132056 | Unfiled - Niet toegekend - Non attribué | 29-Dec-12 | 14:16:36 | 00:16:15 | 31651275403 | Vodafone P-B | Réduit | Outgoing roaming calls | R | 0 | 4.7122 | |||||
Jan-13 | 0470/132056 | Unfiled - Niet toegekend - Non attribué | 29-Dec-12 | 13:27:07 | 00:00:30 | 31651275403 | Vodafone P-B | Réduit | Outgoing roaming calls | R | 0 | 0.145 |
<colgroup><col><col><col><col span="2"><col><col span="2"><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
i need, using a macro, to count and then sum the total amount used for all non working days and calls outside working hours (7.00 am to 7.00 pm / 0700 to 1900)
using an excel formula i was thinking of using the D formula on the date and then count only the ones that have a value equal to 6 or 7.
But i'm quite new to vba and i have no idea how to right a vb code to solve this.