Hi All, can someone help please?
I am making a gnatt chart for daily planning purposes, the format is hours i'm using conditional formatting to show the duration. It works fine apart from when a duration starts before midnight and ends afterwards, at which point anything past midnight will not show.
=AND(W$6>=B$8, W$6<=C$8)
W=00:00, B=start time, C=end time
Last edited by NBVC; 07-15-2009 at 09:58 AM. Reason: added formula from duplicate post
Try
=(W$6>=B$8)+(W$6<=C$8)+C$8<B$8)=2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks