Hi,
Someone can help to me?
I have two time data in column E and column F
For example:
ColumnE
12:30
ColumnF
18:11
The rule is the following:
If StartTime is greater than 12:00pm, then show total hours (column Q) between 18:00 and 22:00
So 12:30 and 18:11 -> 0:11
or 14:15 and 21:15 -> 03:15
or 18:15 and 04:05 -> 03:45
And there is another rule:
If StarTime is greater than 12:00pm, then show total hours (column R) between 22:00 and 06:00
I tried lot of ways in VBA,but it's too complex for me.
Can somebody help to me?
Someone can help to me?
I have two time data in column E and column F
For example:
ColumnE
12:30
ColumnF
18:11
The rule is the following:
If StartTime is greater than 12:00pm, then show total hours (column Q) between 18:00 and 22:00
So 12:30 and 18:11 -> 0:11
or 14:15 and 21:15 -> 03:15
or 18:15 and 04:05 -> 03:45
And there is another rule:
If StarTime is greater than 12:00pm, then show total hours (column R) between 22:00 and 06:00
I tried lot of ways in VBA,but it's too complex for me.
Can somebody help to me?