hi all,
i have my formula in cell original, but i want to change and run in macro now. unfortunately it exceeds over 255 limitation of array formula in macro.
(=IF(INDEX(schedule!$C:$C,MATCH(result!$A51,schedule!$A:$A,0))="","",TEXT(MIN(IFERROR(TIMEVALUE(LEFT(INDEX(schedule!$C:$C,MATCH(result!$A51,schedule!$A:$A,0)):INDEX(schedule!$C:$C,MATCH(result!$A52,schedule!$A:$A,0)-1),5)),1)),"hh:mm")&" - "&TEXT(MAX(IFERROR(TIMEVALUE(MID(INDEX(schedule!$C:$C,MATCH(result!$A51,schedule!$A:$A,0)):INDEX(schedule!$C:$C,MATCH(result!$A52,schedule!$A:$A,0)-1),7,5)),0)),"hh:mm")))
how can i do it with a macro? or any other way that i can spilt my original one to 2 formulas and then still run in macro?
my request: xx:xx - xx:xx on time format, start & end time only
<tbody>
</tbody>
thanks for doing this
kelvin
i have my formula in cell original, but i want to change and run in macro now. unfortunately it exceeds over 255 limitation of array formula in macro.
(=IF(INDEX(schedule!$C:$C,MATCH(result!$A51,schedule!$A:$A,0))="","",TEXT(MIN(IFERROR(TIMEVALUE(LEFT(INDEX(schedule!$C:$C,MATCH(result!$A51,schedule!$A:$A,0)):INDEX(schedule!$C:$C,MATCH(result!$A52,schedule!$A:$A,0)-1),5)),1)),"hh:mm")&" - "&TEXT(MAX(IFERROR(TIMEVALUE(MID(INDEX(schedule!$C:$C,MATCH(result!$A51,schedule!$A:$A,0)):INDEX(schedule!$C:$C,MATCH(result!$A52,schedule!$A:$A,0)-1),7,5)),0)),"hh:mm")))
how can i do it with a macro? or any other way that i can spilt my original one to 2 formulas and then still run in macro?
my request: xx:xx - xx:xx on time format, start & end time only
Name | Time | outcome | |||||
Ada | 13:00-22:45 | 13:00 - 22:45 | |||||
Ted | 13:15-15:00 | 13:15 - 22:45 | |||||
15:00-21:15 | |||||||
21:15-22:00 | |||||||
22:00-22:45 | |||||||
Kathy | 9:00-12:15 | 09:00 - 18:30 | |||||
12:15-18:30 |
<tbody>
</tbody>
thanks for doing this
kelvin