Thread: Program with Hours
View Single Post
 
Old 08-20-2017, 06:27 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
In D1 this should also look after time that crosses midnight.

=IF(OR(A1="",B1=""),0,IF(OR(C1="x",E1="x"),(((B1-A1)+(B1<A1))*24)-0.5,((B1-A1)+(B1<A1))*24))
Reply With Quote