One way:

=INT((MIN(IssueClosed,NOW()) - IssueLogged)*24)

In article ,
Dazed&confused! wrote:

HI

Apologies for this - I just seem to have left my brain at home today.

Essentially I'm calculating the time difference in hours between IssueLogged
and IssueClosed - this bit I have solved ...
=int(IssueClosed-IssueLogged)*24) ...., but the second part I need is if
IssueClosed is empty, get Excel use the current date and use this to show how
long it has been since the Issue was logged.

any/all help appreciated!
D