I changed Const sFORMULATE to "=IF(NOW()-INT(NOW())-RC[-1]<0.04167,NOW()-INT(NOW())-RC[-1],0.04167)" and was able to have each line item stop as an hour. This made our project exactly as we had hoped, thank you for your help!
I changed Const sFORMULATE to "=IF(NOW()-INT(NOW())-RC[-1]<0.04167,NOW()-INT(NOW())-RC[-1],0.04167)" and was able to have each line item stop as an hour. This made our project exactly as we had hoped, thank you for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks