The value is just a value and not a formula
times are stored as a fraction of a day so 4:40 = 280minutes out of a
total of 1440 minutes and hence as a formula it just shows its value
280/1440=0.194444444444444
Regards
Dav
--
Dav
------------------------------------------------------------------------
Dav's Profile:
http://www.excelforum.com/member.php...o&userid=27107
View this thread:
http://www.excelforum.com/showthread...hreadid=554009