Calculating time in Google Sheets - Ablebits
https://www.ablebits.com/office-addins-blog/calculating-time-google-sheets/
WEBApr 3, 2024 · If you work in Google Sheets & your chat start time is in A2, reply time start is in B9, this formula will help: =IF(OR(A2>=TIME(13,0,0),B2<=TIME(9,0,0)),0,MAX(MIN(B2,TIME(12,0,0))-MAX(A2,TIME(9,0,0)),0)+MAX(MIN(B2,TIME(17,0,0))-MAX(A2,TIME(13,0,0)),0))
DA: 6 PA: 74 MOZ Rank: 6 Up or Down: Up