Help with a IF statement

[Frank3923]

I have tried creating a IF statement, that says IF K2 is empty, insert value from M2. IF K2 has a clock time, Use it has time out. I have tried using the following TEXT(IF(M6<C6,1-C6+L6,L6-C6),"hh:mm

Daily-Plan-Work-Hours-Worksheet-Tuesday-101006.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	NAME		Start Time	Clock In	Current Time	Time On Duty				Running Time On Duty	Out Time	8 Hours Up @	Time On Less Lunch			Lunch
2	Alward	Pete	7:00	7:00	8:47	1:47	01:47			1:17			1:17	1.289558	1:47	:30
3	Balcom	Glen	6:00	6:00	8:47	2:47	02:47			2:17			2:17	2.289558	2:47	:30
Test

 

[bsnapool]

wouldnt this do it?

=IF(K5="",P5,P5)

 

[onlyadrafter]

Hello,

part of your post seems to be missing.

is it

=IF(ISBLANK(K2),M2,K2)