S
Steved
Hello from Steved
I was kindly given the below formula's
=IF(AND(ISNUMBER(C3),ISNUMBER(T3)),HOUR(IF(T5>0.5,T3-0.5,IF
(T3<1/24,T3+0.5,T3)))&TEXT(MINUTE(T3),"00"),"")
and
IF(COUNT(C3,T3),SUBSTITUTE(LEFT(TEXT(T3, "H:MM
AM/PM"),5),":", ""),"")
The below works
HOUR(IF(T3>0.5,T3-0.5,IF(T3<1/24,T3+0.5,T3)))&TEXT(MINUTE
(T3),"00")
What is happening the 2 that I was given creates a circular
I understand it is possibly to do with reading a Formula
in T3.
What I am hopping is that the 2 formulas i was given can
be altered to reflect reading a formuls and make the cell
blank please.
Thankyou.
I was kindly given the below formula's
=IF(AND(ISNUMBER(C3),ISNUMBER(T3)),HOUR(IF(T5>0.5,T3-0.5,IF
(T3<1/24,T3+0.5,T3)))&TEXT(MINUTE(T3),"00"),"")
and
IF(COUNT(C3,T3),SUBSTITUTE(LEFT(TEXT(T3, "H:MM
AM/PM"),5),":", ""),"")
The below works
HOUR(IF(T3>0.5,T3-0.5,IF(T3<1/24,T3+0.5,T3)))&TEXT(MINUTE
(T3),"00")
What is happening the 2 that I was given creates a circular
I understand it is possibly to do with reading a Formula
in T3.
What I am hopping is that the 2 formulas i was given can
be altered to reflect reading a formuls and make the cell
blank please.
Thankyou.