Getting Difference between two cells
Jimmydageek wrote:
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
format those cells as time 00:00:00 and then subtract them
0:30:40-0:20:30=0:10:10 ...... the o is 12 AM as this is a 24 hour format
|