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
Show us some examples of the data being processed, all types, the formula just looks like nonsense in isolation.
Bookmarks