A couple of questions

D

Dave

Time Calculation

What calculation do I use to find how many hours have past between say ?

Cell A1: Friday 20:00PM to Cell B1: Monday 06:00AM for instance

Also

what format do I need to use so that when I am not calculating it just
shows a 0 in the cell

Cheers

Dave
 
V

VBA Noob

Hi,

Try =IF(OR(A1="",B1=""),"",IF(A1>B1,B1+1-A1,B1-A1))

format cell as HH:MM

VBA Noob
 
V

VBA Noob

Hi,

Try =IF(OR(A1="",B1=""),"",IF(A1>B1,B1+1-A1,B1-A1))

format cell as HH:MM

VBA Noob
 
Top