A couple of questions

[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

 

[VBA Noob]

Hi,

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

format cell as HH:MM

VBA Noob

 

[VBA Noob]

Hi,

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

format cell as HH:MM

VBA Noob

 

[Bernard Liengme]

Maybe use format [h]:mm to allow for hours > 24?

 

[VBA Noob]

Agreed

VBA Noob

Maybe use format [h]:mm to allow for hours > 24?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

Hi,

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

format cell as HH:MM

VBA Noob

 

[VBA Noob]

Agreed

VBA Noob

Maybe use format [h]:mm to allow for hours > 24?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

Hi,

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

format cell as HH:MM

VBA Noob