Excel VBA: Subtracting TIMES

[Lazer]

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

Thanks

 

[Chip Pearson]

Try the following formula:

=(A2-A1)*60*24



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Tom Ogilvy]

=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.