Calculating lost hours between dates
I wrote a formula to calculate the hours lost on a product cell due to down time, it meant to calculate 8 hours for a day but it counts 16 hours if the cell stops for a day as it counts starting date and closing date as 2 different days instead of just one single day down. I need to count 8 hours is the event closes the same day and substract 8 hours if the starting and the closing date are different.
I can write on Excel but i seem to have a hard time picturing it in Smartsheets.
=IF(ISDATE([Closing Date]@row), NETWORKDAY([Event IDate]@row, [Closing Date]@row) * 8)
Help Article Resources
Check out the Formula Handbook template!