View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dav
 
Posts: n/a
Default displaying formulas


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