=A2-A1

format as hh:mm:ss

or

=(A2-A1)*24*60

and format as general if you want a number (rather than a time value) like
15 as the answer.

--
Regards,
Tom Ogilvy

"Lazer" wrote in message
...

If cell A1 = "5:00 PM" and cell A2 = "5:15 PM", what should the formula
for A3 be if I want to display the difference - i.e. 15 minutes?

Thanks!


--
Lazer
------------------------------------------------------------------------
Lazer's Profile:
http://www.excelforum.com/member.php...fo&userid=7500
View this thread: http://www.excelforum.com/showthread...hreadid=277018