I am trying to figure out lost time during a worker's day....
Lost time = 0:00:00 (Column AC) "Not Available"
+
Lost Time = 0:00:00 (Column AL) "Not Ready"
$V$4 = 1:30:00
This calculation works: =IF(ISBLANK(U102),TIME(0,0,0),SUM(AC102,AL102)-$V$4)
I'm trying to make sure that if there are no entries in the worksheet yet, the cell will remain blank until data is added so here's the breakdown (My thoughts)
If U102 is blank, enter 0:00:00, but if it is not empty enter the total Lost Time - 1:30:00 (Lunch and breaks) to provide complete and total lost time.
Problem is, some of the time personnel work through lunches so the result is negative after subtracting the 1:30:00 and the cell contains #################
SO, I'm trying to do an ISERROR statement and I'm lost...
=IF(ISERROR(ISBLANK(U99),TIME(0,0,0),SUM(AC99,AL99)-$V$4)<0,"0",(SUM(AC99,AL99)))
Can someone please help me think this through, I'm at my wit's end... now I'm getting a #VALUE! response.... and...I need it to be a formula not VB because if its VB and it breaks, I can't fix it ... I'm not knowledgeable about VB, syntax and the like.
HELP
LadyCK3
aka: Laurie
Lost time = 0:00:00 (Column AC) "Not Available"
+
Lost Time = 0:00:00 (Column AL) "Not Ready"
$V$4 = 1:30:00
This calculation works: =IF(ISBLANK(U102),TIME(0,0,0),SUM(AC102,AL102)-$V$4)
I'm trying to make sure that if there are no entries in the worksheet yet, the cell will remain blank until data is added so here's the breakdown (My thoughts)
If U102 is blank, enter 0:00:00, but if it is not empty enter the total Lost Time - 1:30:00 (Lunch and breaks) to provide complete and total lost time.
Problem is, some of the time personnel work through lunches so the result is negative after subtracting the 1:30:00 and the cell contains #################
SO, I'm trying to do an ISERROR statement and I'm lost...
=IF(ISERROR(ISBLANK(U99),TIME(0,0,0),SUM(AC99,AL99)-$V$4)<0,"0",(SUM(AC99,AL99)))
Can someone please help me think this through, I'm at my wit's end... now I'm getting a #VALUE! response.... and...I need it to be a formula not VB because if its VB and it breaks, I can't fix it ... I'm not knowledgeable about VB, syntax and the like.
HELP
LadyCK3
aka: Laurie