Hi,

I am trying to do some simple math, but it will include the MOD
function, and I can't get the result I need.

what I have is one column of datetime (dd/mm/yy hh:mm) and another
column of just time (hh:mm). I need to subtract the TIME ONLY in the
datetime column from the time column. This is what I thought was right,
but it doesn't seem to be.

=(K3-(MOD(MARIE_STATS!A3,1)))

The answer I get is -0.82 if the cell is formatted as a "Number". If I
try to format it as "Time" (hh:mm) I get all #########. The actualy
value in this case should be 00:37 (37 minutes. So, somewhere I be
messing up, can someone straighten me out please?

FYI cell K3 is the higher value so I shouldn't bet a negative.

Thanks,
Brian


--
Gadgets
------------------------------------------------------------------------
Gadgets's Profile: http://www.excelforum.com/member.php...o&userid=36784
View this thread: http://www.excelforum.com/showthread...hreadid=565354