Quick Formula to Calculate Time

[frank265]

Hi all,

Hoping someone can help with a simple IF calculation... I wanted a quick formula to calculate the time spent on a task but for the calculation only to be made if the cellls are not blank. Example below

Start Time	End Time	Total Time
08:00	12:00	04:00
		NOTHING WRITTEN HERE AS CELLS ARE BLANK

So nothing would be written in the Total Time Column if either the Start Time, End Time or both are blank...

Thank you for reading.

 

[Kerryx]

=IF(OR(A2="",B2=""),"",B2-A2)

 

[frank265]

=IF(OR(A2="",B2=""),"",B2-A2)

This is awesome - thank you so much Kerryx!!!! Wish you a brilliant day ahead

 

[Kerryx]