One way:

A1: 3.08
A2: 2.28
A3: =(SUBSTITUTE(A1,".",":") - SUBSTITUTE(A2,".",":")) * 1440

In article ,
Rick wrote:

I have times entered a minutes and seconds - 3.08 being 3 minutes and 8
seconds.

I want to subtract 2.28 which would be 40 seconds, but obviously decimals
returns 0.80.

How do I get this to show 40?

Thanks
Rick