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
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