Hello.
I have no experience with Excel. I recently accepted a part time job with a startup, and I am required to log my own hours every week. I found a sheet I'd like to use, but it has lunch hours included which doesn't apply to me. I will be changing the Lunch In and Lunch Out columns to be the Primary Project and Secondary Project I was working on during these hours worked.
For the hours worked column, which is calculating the Time In column, Time Out column, Lunch In column, and Lunch Out column, I would like to completely remove Lunch In and Lunch Out from the formula to have it still work with only Time In and Time Out.
Here it is: =IFERROR(IF(COUNT(TimeSheet[@[Time In]:[Time Out]])=4,(IF([@[Time Out]]<[@[Time In]],1,0)+[@[Time Out]])-[@[Time In]],IF(AND(LEN([@[Time In]])<>0,LEN([@[Time Out]])<>0),(IF([@[Time Out]]<[@[Time In]],1,0)+[@[Time Out]])-[@[Time In]],0))*24,0)
I would be very grateful for assistance! Thanks in advance.
I have no experience with Excel. I recently accepted a part time job with a startup, and I am required to log my own hours every week. I found a sheet I'd like to use, but it has lunch hours included which doesn't apply to me. I will be changing the Lunch In and Lunch Out columns to be the Primary Project and Secondary Project I was working on during these hours worked.
For the hours worked column, which is calculating the Time In column, Time Out column, Lunch In column, and Lunch Out column, I would like to completely remove Lunch In and Lunch Out from the formula to have it still work with only Time In and Time Out.
Here it is: =IFERROR(IF(COUNT(TimeSheet[@[Time In]:[Time Out]])=4,(IF([@[Time Out]]<[@[Time In]],1,0)+[@[Time Out]])-[@[Time In]],IF(AND(LEN([@[Time In]])<>0,LEN([@[Time Out]])<>0),(IF([@[Time Out]]<[@[Time In]],1,0)+[@[Time Out]])-[@[Time In]],0))*24,0)
I would be very grateful for assistance! Thanks in advance.