View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken Wright Ken Wright is offline
external usenet poster
 
Posts: 634
Default How to subtract[difference] in TIMES??

Some good explanations and examples:-

http://cpearson.com/excel/datearith.htm

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"Crackles McFarly" wrote in message
...
12:15 pm
12:44 pm
12:45 pm
12:59 pm
then
12:01 am
12:09 am
12:19 am

The differences aren't the same, they change and that is that Number I
wish to calculate/display in another Cell

With about 22 entries in between, not of the same interval.

I'd REALLY appreciate some help with this problem.

How can you subtract the times each time so you can Display the "time
interval"?