Calculate difference of time

[torf66]

I have two cells that have time in them. I want to be able to calculate the difference between the values.
For example cell A1 has 14:45 in it and cell B2 has 15:10 in it. I want to subtract the difference and return a value in cell A3 of 25minutes. How can this be done in Excel?
Thanks,
Todd
ttorfin@dakcl.com

 

[SkipVought]

Hi,

[tt]
=B2-A1
[/tt]
format cell as time.

Skip,
[sub]
[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large! [/sub]

 

[SkipVought]

or in vba

with [a3]
  .value = [b2]-[a1]
  .numberformat = "hh:mm"
end with

Skip,
[sub]
[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large! [/sub]