How to calculate Night Differential

Hello bobika,

My suggestion here addresses a specific situation where C2 and D2 contain dates and times - from your comments it seems that you have cells with times only so it's a different situation.

Please start your own thread if you have a separate problem that you can't resolve, thanks