Help with a IF statement

Frank3923

Board Regular
Joined
Jan 20, 2003
Messages
244
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
ABCDEFGHIJKLMNOP
1NAMEStart TimeClock InCurrent TimeTime On DutyRunning Time On DutyOut Time8 Hours Up @Time On Less LunchLunch
2AlwardPete7:007:008:471:4701:47 1:17 1:171.2895581:47:30
3BalcomGlen6:006:008:472:4702:47 2:17 2:172.2895582:47:30
Test
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

onlyadrafter

Well-known Member
Joined
Aug 19, 2003
Messages
5,703
Platform
  1. Windows
Hello,

part of your post seems to be missing.

is it

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

Watch MrExcel Video

Forum statistics

Threads
1,113,857
Messages
5,544,694
Members
410,630
Latest member
Maggie28
Top