D
Dan
I created a time sheet which contains the following field: Time In (column
c), Time Out (column d), Time In (column e), Time Out (column f). The second
time in and out is for lunch out and lunch in.
The next step is calculate the hours. There are 5 columns. First column to
calculate up to 8 hrs, second column is anything betwen 9 and 12 hours, third
column is 12+ columns. Each of these sets assume a deduction for lunch (the
second time in and time out).
Now, the problem - the fourth column, assuming that no lunch but my
calculation is not working. Here's the formula
if(d12="",0)*AND(e12="",0),round(f14-c14)*24,2). Any help would be
appreciated.
c), Time Out (column d), Time In (column e), Time Out (column f). The second
time in and out is for lunch out and lunch in.
The next step is calculate the hours. There are 5 columns. First column to
calculate up to 8 hrs, second column is anything betwen 9 and 12 hours, third
column is 12+ columns. Each of these sets assume a deduction for lunch (the
second time in and time out).
Now, the problem - the fourth column, assuming that no lunch but my
calculation is not working. Here's the formula
if(d12="",0)*AND(e12="",0),round(f14-c14)*24,2). Any help would be
appreciated.