I do need it to subtract...
--
Randy Street
Rancho Cucamonga, CA


"jordun" wrote:


Hi
he p[roblem seems to be the sybtax of the ranges in the SUM functions

=IF(ISBLANK('Check-In'!F4),SUM((D8-C8)*24),SUM((F8-E8)*24,(D8-C8)*24))

1 - SUM((D8-C8)*24)-- the range syntax is C8:D8, when you write D8-C8
you are telling Excel D8 minus C8

2 - The same for SUM((F8-E8)


I guess your formula should look like this:
=IF(ISBLANK('Check-In'!F4),SUM((D8:D8)*24),SUM((F8:E8)*24,(D8:C8)*24) )


--
jordun


------------------------------------------------------------------------
jordun's Profile: http://www.excelforum.com/member.php...o&userid=33118
View this thread: http://www.excelforum.com/showthread...hreadid=530162