Understanding the formula...

[Jai]

Hi,

I have the following formula that helps me format time. All I need is to understand it a little more.

=CEILING(IF(ISNUMBER(A2),A2,VALUE(LEFT(A2,LEN(A2)-3)&":00")+IF(AND(RIGHT(A2,2)="PM",LEFT(A2,2)<>"12"),0.5,0))-"00:45:00",--"01:00:00")

Can someone help me with a 2-3 line explanation or more as you may deem fit.

Thanks in advance!

Jai

[Bob Phillips]

Show us some examples of the data being processed, all types, the formula just looks like nonsense in isolation.