DALE1612
New member
- Joined
- Sep 22, 2015
- Messages
- 18
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2007
Here is the formula that I am working with. =IF(COUNT(F69,I69)=2,MAX(0,MIN($C$6,I69)-MAX($C$5,F69))*24,""))
I am running this formula and it is recording working hours for everyday of the week, I don't want to record weekend times, but I need to record a zero "0" for the weekends
The weekend is Sat & Sun. Could this formula be adjusted to exclude weekends. My day & date is in Column "A" and this formula is in Column "K"
Thanks..
I am running this formula and it is recording working hours for everyday of the week, I don't want to record weekend times, but I need to record a zero "0" for the weekends
The weekend is Sat & Sun. Could this formula be adjusted to exclude weekends. My day & date is in Column "A" and this formula is in Column "K"
Thanks..