View Single Post
  #4   Report Post  
MrShorty
 
Posts: n/a
Default


Put an equals sign in front and Excel will treat it as a formula. So
=7-3 will display 4.

If you want to format it so Excell displays it in one of the many time
formats, then you have to learn to think of time in terms of fractions
of a day. So (assuming those are hours) =7/24-3/24 then formatted as
[h]:mm:ss will display 04:00:00


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=467241