Thanks for your help, one note, the value in K4 is automated by another cell
and has to be time, not text, however i will try it anyway. thanks again

"MS-Exl-Learner" wrote:

Try this.

In cell V4 Paste this formula:-
=IF(H4="D",K4,"00:00")

In cell Y4 Paste this formula:-
=IF(H4="N",K4,"00:00")

Format the K4 value as Text and type 00:45

If this post helps, click yes!

--------------------
(MS-Exl-Learner)
--------------------



"v1rt8" wrote:

H4 contains D or N
K4 contains time 00:45
V4 would return value of K4 if H4 = D,otherwise 00:00
Y4 would return value of K4 if H4 = N, otherwise 00:00

have been looking through all the questions and cant find, would greatly
appreciate
thanks