Calculating difference in time - conditional formatting

Mux99

New Member
Joined
Apr 15, 2019
Messages
25
Hi all

I would like to calculate Time-in - Time-out and if there is less than a 9 hour difference, highlight the cells. In the example below B4:B5 & C2:C3 would be highlighted.

Time-inTime-outTime-inTime-outTime-inTime-out
08:0018:0009:0022:0006:0017:00
12:0023:0007:0016:0010:0019:00

<tbody>
</tbody>
 

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Hi,

Not quite sure about your example

In the example below B4:B5 & C2:C3 would be highlighted.
Where are all these cells exactly ?
 

Mux99

New Member
Joined
Apr 15, 2019
Messages
25
Hi,

Not quite sure about your example

Where are all these cells exactly ?
Sorry about that as I did not copy the whole table. I meant to say D2:E2 & B3:C3. Please see the example below

ABCDEF
1Time-inTime-outTime-inTime-outTime-inTime-out
208:0018:0009:0022:0006:0017:00
312:0023:0007:0016:0010:0019:00

<tbody>
</tbody>
 
Last edited:

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Hello,

Thanks for your clarification ...

For your range B2:F3 you can have following formula

Code:
=MOD(B2-A2,1)<0.375
Hope this will help
 

Forum statistics

Threads
1,085,171
Messages
5,382,125
Members
401,773
Latest member
BredAnderson

Some videos you may like

This Week's Hot Topics

Top