Now it works in that cell - I don't know what I'm doing wrong, but I used the
paste special on another cell and it is not returning the correct value. The
cell references in the formula seem fine.

This is what I have:
Cell G11 = 12:44 AM
Cell C11 = 11:57 PM
The formula in cell I11 is =(((G11-C11)*60)*24)&" min." and the result is
-1393 mins. It must have something to do with the fact that it's AM minus
PM. How can this be fixed?

Thank you VERY much for all your help, Karen



"Nick Hodge" wrote:

Karen

Worked for me...are you sure your formula reads as below

=(((F5-D5)*60)*24)&" mins"

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Karen" wrote in message
...
Thank you for your help - I used =(((G5-C5)*60)*24)&" mins" and it worked
great.
I did a paste special and pasted that formula into another cell and it's
not
working as planned.

I have:
Cell F5 = 1:28 AM
Cell D5 = 1:12 AM
I want the difference of F5-D5, which is 16 minutes. How do I get a
return
of "16 mins"?

Thank you, Karen

"Nick Hodge" wrote:

Karen

=(((G5-C5)*60)*24)

Will give you 43. If you are using the number in a calc after that then
custom format (FormatCells...Custom) and enter 0 "mins"

If you are not using the result then add to the formula

=(((G5-C5)*60)*24)&" mins"

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Karen" wrote in message
...
This is the scenario:

Cell G5 = 1: 39 AM
Cell C5 = 12:56 AM
Cell I5 = (Formula) =G5-C5

The result is 0:43
Is there any way to return a result of 43 min. instead of 0:43?

Any help would be greatly appreciated - Thank you, Karen