Modifiting Counting Times Formula

[adinek22]

Hello All,

can you please help me guys with something. I have a formula like that =IFERROR(((AC40-AB40+IF(AC40<AB40,1,0))*24)-0.5,) and i need to add to it if AC or AB blank then leave it as 0 because at the moment its showing as -0.5 which is right when i have something in AC or AB.

[teylyn]

Why post this in the VBA forum? It's a formula. Try

=IF(OR(ISBLANK(AC40),ISBLANK(AB40)),0,IFERROR(((AC40-AB40+IF(AC40<AB40,1,0))*24)-0.5,))

cheers, teylyn

[adinek22]

I do apologise posted it in worng place by mistake. Formula is working, thank you very much )

[teylyn]

Glad it worked for you. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.