In Excel the Absolute value is calculated by using the ABS function so
maybe something like:
In cell E2 =MIN(10,(*(ABS*(D2-B2)*+24)**24-C2))
or wherever that minus number might be calculated
Sorry, I don't think that would work :(
0300 - 2300 = -2000
-2000 + 2400 = 0400 (which would work)
2300 - 2000 = 0300 (which is what you want)
0300 + 2400 = 2700 (which isn't what you want)
Perhaps with In cell E2 =MIN(10,((D2-B2)+2400*24-C2))
Then IF E22400 THEN -2400 ELSE END
or something along those lines ???
--
Daminc
------------------------------------------------------------------------
Daminc's Profile:
http://www.excelforum.com/member.php...o&userid=27074
View this thread:
http://www.excelforum.com/showthread...hreadid=467159