View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Matt[_4_] Matt[_4_] is offline
external usenet poster
 
Posts: 1
Default Time calculations

I'm trying to work out the formula to calculate time variances. I need to
display minutes as a number so it can be included in a CONCATENATE formula.
In addition to this, how do I calculate a sum such as 23:00 - 02:00? When
using a number, or general format in the result cell, excel doesn't return
the rersult I want. 180 (mins)