Hi
I'm using a formula to calculate time duration basically tells me total day/hours passed from daily time stamps. The formula below pulls the time stamp from one column but if the column has no time (blank) the formula does work. Where do I modify this formula to ignore cells with no time?
=INT((A200-A3)*24)&":"&TEXT(A200-A3,"hh:mm")
Bookmarks