With start date in A1 and finish date in B1, use this:

=MOD(B1-A1,1)*24*60

and format the cell as General to give you 180 (minutes).

To control the format of the number in your concatenation formula, use
something like this:

TEXT(C1,"0.00")

to give you 2 decimal places.

Hope this helps.

Pete


On Jan 26, 10:53*pm, Matt
wrote:
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)