Microsoft Office Forums - View Single Post - [Solved] Calculate counts between fluid rows - TIME

Thread: [Solved] Calculate counts between fluid rows - TIME

View Single Post

Old

01-18-2017, 04:09 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

Hi Rob,

You are welcome and thanks for the feedback.

If you want a formula solution, this seems to work on your sample date...

D2 copied to the right >> =COUNTIF($B$2:$B$431,"<"&TIME(7,0,0)+(0.0416666666 666667*(COLUMN(A1)-1)))-SUM($C$2:C2)

Reply With Quote