View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jimmydageek
 
Posts: n/a
Default Getting Difference between two cells


OK I have two cells (different than last posting) that have times listed
in there as shown below.

:20:30
and
:30:40

I want to get the difference between these two cells to show in a third
area so I can see lets say -:10:10 like D2-D1. I try to do this now
but get the #Value! Error. And no Formatting cells helps. How would I
go about this?

TIA.
Jimmy


--
Jimmydageek
------------------------------------------------------------------------
Jimmydageek's Profile: http://www.excelforum.com/member.php...o&userid=31692
View this thread: http://www.excelforum.com/showthread...hreadid=513936