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

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

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

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

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

Karen

Excel handles dates and times as whole numbers since Jan 1st 1900 (Day 1),
with times being decimals of a day (.5 is 12 noon), it is just formatting
that makes them look like times.

Your times are crossing midnight and taking no account of the day.

I would direct you here to understand how Excel handles dates and times and
therefore what my original formula is doing

www.cpearson.com/excel/datetime.htm

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


"Karen" wrote in message
...
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

Hi Karen

One way to deal with times crossing the midnight barrier, is to use
=MOD(G11-C11,1) instead of plain G11-C11

Therefore modifying Nick's formula to
=(((MOD(G11-C11,1))*60)*24)&" min."

or even removing Nick's penchant for brackets ( no offence Nick <bg)
=MOD(G11-C11,1)*60*24 &" min."
will give you the correct answer of 47 min

--
Regards

Roger Govier


"Karen" wrote in message
...
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

You could use =(G5-C5)*24*60 and format as 00 "min"
--
David Biddulph

"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

Thank you for your help - Is that a custom format?

"David Biddulph" wrote:

You could use =(G5-C5)*24*60 and format as 00 "min"
--
David Biddulph

"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

Yes.
--
David Biddulph

"Karen" wrote in message
...
Thank you for your help - Is that a custom format?

"David Biddulph" wrote:

You could use =(G5-C5)*24*60 and format as 00 "min"
--
David Biddulph

"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