Wouldn't the A1/1440 part of my formula convert a "text number" into a real
number in order to perform the division?

Rick


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
It sounds as if A1 doesn't contain a number, but instead contains some
form of text. What does =ISNUMBER(A1) show?
--
David Biddulph

"James" wrote in message
...
Thank but that just gives me a reply of #VALUE
Am i doing something wrong in my formulae?
I copied and paste yours and changed the cell reference but it still
dunna
work!!!
Grrrrr pulling my hair out here!


"Rick Rothstein (MVP - VB)" wrote:

At the end of the day it becomes a bit more complicated, it could be
107minutes. This is easy to understand in it's self. Yet I need a
formulae
that would convert the 107 (which is a general number with no decimal
places)
into a time which should be 1 Hour 47 minutes

This formula will do that...

=TEXT(A1/1440,"[h] ""hours"" mm ""minutes""")

where A1 is assumed to have your 107 minute result.

Rick

Yes, so the text would have to contain more than just the number.
--
David Biddulph

"Rick Rothstein (MVP - VB)" wrote in
message ...
Wouldn't the A1/1440 part of my formula convert a "text number" into a
real number in order to perform the division?

Rick


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
It sounds as if A1 doesn't contain a number, but instead contains some
form of text. What does =ISNUMBER(A1) show?
--
David Biddulph

"James" wrote in message
...
Thank but that just gives me a reply of #VALUE
Am i doing something wrong in my formulae?
I copied and paste yours and changed the cell reference but it still
dunna
work!!!
Grrrrr pulling my hair out here!


"Rick Rothstein (MVP - VB)" wrote:

At the end of the day it becomes a bit more complicated, it could be
107minutes. This is easy to understand in it's self. Yet I need a
formulae
that would convert the 107 (which is a general number with no decimal
places)
into a time which should be 1 Hour 47 minutes

This formula will do that...

=TEXT(A1/1440,"[h] ""hours"" mm ""minutes""")

where A1 is assumed to have your 107 minute result.

Rick

Whatever i try doesn't give me what i want.
"Rick Rothstein (MVP - VB)" wrote:

Wouldn't the A1/1440 part of my formula convert a "text number" into a real
number in order to perform the division?

Rick


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
It sounds as if A1 doesn't contain a number, but instead contains some
form of text. What does =ISNUMBER(A1) show?
--
David Biddulph

"James" wrote in message
...
Thank but that just gives me a reply of #VALUE
Am i doing something wrong in my formulae?
I copied and paste yours and changed the cell reference but it still
dunna
work!!!
Grrrrr pulling my hair out here!


"Rick Rothstein (MVP - VB)" wrote:

At the end of the day it becomes a bit more complicated, it could be
107minutes. This is easy to understand in it's self. Yet I need a
formulae
that would convert the 107 (which is a general number with no decimal
places)
into a time which should be 1 Hour 47 minutes

This formula will do that...

=TEXT(A1/1440,"[h] ""hours"" mm ""minutes""")

where A1 is assumed to have your 107 minute result.

Rick

So what does =A1/1440 give, and exactly what does A1 contain, and (question
from earlier) what does =ISNUMBER(A1) show?
--
David Biddulph

"James" wrote in message
...
Whatever i try doesn't give me what i want.

"Rick Rothstein (MVP - VB)" wrote:

Wouldn't the A1/1440 part of my formula convert a "text number" into a
real
number in order to perform the division?

Rick


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
It sounds as if A1 doesn't contain a number, but instead contains some
form of text. What does =ISNUMBER(A1) show?
--
David Biddulph

"James" wrote in message
...
Thank but that just gives me a reply of #VALUE
Am i doing something wrong in my formulae?
I copied and paste yours and changed the cell reference but it still
dunna
work!!!
Grrrrr pulling my hair out here!


"Rick Rothstein (MVP - VB)" wrote:

At the end of the day it becomes a bit more complicated, it could
be
107minutes. This is easy to understand in it's self. Yet I need a
formulae
that would convert the 107 (which is a general number with no
decimal
places)
into a time which should be 1 Hour 47 minutes

This formula will do that...

=TEXT(A1/1440,"[h] ""hours"" mm ""minutes""")

where A1 is assumed to have your 107 minute result.

Rick

Hi
=A1/1440
gives me 0.74444
the other one gives me true.

"David Biddulph" wrote:

So what does =A1/1440 give, and exactly what does A1 contain, and (question
from earlier) what does =ISNUMBER(A1) show?
--
David Biddulph

"James" wrote in message
...
Whatever i try doesn't give me what i want.

"Rick Rothstein (MVP - VB)" wrote:

Wouldn't the A1/1440 part of my formula convert a "text number" into a
real
number in order to perform the division?

Rick


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
It sounds as if A1 doesn't contain a number, but instead contains some
form of text. What does =ISNUMBER(A1) show?
--
David Biddulph

"James" wrote in message
...
Thank but that just gives me a reply of #VALUE
Am i doing something wrong in my formulae?
I copied and paste yours and changed the cell reference but it still
dunna
work!!!
Grrrrr pulling my hair out here!


"Rick Rothstein (MVP - VB)" wrote:

At the end of the day it becomes a bit more complicated, it could
be
107minutes. This is easy to understand in it's self. Yet I need a
formulae
that would convert the 107 (which is a general number with no
decimal
places)
into a time which should be 1 Hour 47 minutes

This formula will do that...

=TEXT(A1/1440,"[h] ""hours"" mm ""minutes""")

where A1 is assumed to have your 107 minute result.

Rick

That means that A1 is about 107.2, not 107.0, but there doesn't seem any
sensible reason why you should get #VALUE! from the
=TEXT(A1/1440,"[h] ""hours"" mm ""minutes""") formula.
Are you sure that your formula is referring to the correct cell, on the
correct sheet?
--
David Biddulph

"James" wrote in message
...
Hi
=A1/1440
gives me 0.74444
the other one gives me true.

"David Biddulph" wrote:

So what does =A1/1440 give, and exactly what does A1 contain, and
(question
from earlier) what does =ISNUMBER(A1) show?
--
David Biddulph

"James" wrote in message
...
Whatever i try doesn't give me what i want.

"Rick Rothstein (MVP - VB)" wrote:

Wouldn't the A1/1440 part of my formula convert a "text number" into a
real
number in order to perform the division?

Rick


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
It sounds as if A1 doesn't contain a number, but instead contains
some
form of text. What does =ISNUMBER(A1) show?
--
David Biddulph

"James" wrote in message
...
Thank but that just gives me a reply of #VALUE
Am i doing something wrong in my formulae?
I copied and paste yours and changed the cell reference but it
still
dunna
work!!!
Grrrrr pulling my hair out here!


"Rick Rothstein (MVP - VB)" wrote:

At the end of the day it becomes a bit more complicated, it
could
be
107minutes. This is easy to understand in it's self. Yet I
need a
formulae
that would convert the 107 (which is a general number with no
decimal
places)
into a time which should be 1 Hour 47 minutes

This formula will do that...

=TEXT(A1/1440,"[h] ""hours"" mm ""minutes""")

where A1 is assumed to have your 107 minute result.

Rick

I think you are going to have to give us some additional information. If
there is a formula in the cell with the 107 in it, copy/paste it into a
response to us. Also, tell us exactly what is displayed in the cell (and
what side of the cell it is on... left or right side). If there is a formula
in the cell, tell us what is in any referenced cells (that is, if your
formula uses C5 in it, tell us what is in C5). Right-click the cell and
select Format Cells from the popup menu... what item in the Category list
(on the Number tab) is selected? If Custom, tell us what custom format
string is shown in the Type field. Oh, and is this cell part of a merged set
of cells? You could also tell us anything else you might have done "out of
the ordinary" to the cell.

Better yet would be if you could put the spreadsheet up on a webpage
somewhere so that we could download it and look at it directly (of course,
if you do this, tell us what cell or cells we should be looking at).

Rick


"James" wrote in message
...
Whatever i try doesn't give me what i want.
"Rick Rothstein (MVP - VB)" wrote:

Wouldn't the A1/1440 part of my formula convert a "text number" into a
real
number in order to perform the division?

Rick


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
It sounds as if A1 doesn't contain a number, but instead contains some
form of text. What does =ISNUMBER(A1) show?
--
David Biddulph

"James" wrote in message
...
Thank but that just gives me a reply of #VALUE
Am i doing something wrong in my formulae?
I copied and paste yours and changed the cell reference but it still
dunna
work!!!
Grrrrr pulling my hair out here!


"Rick Rothstein (MVP - VB)" wrote:

At the end of the day it becomes a bit more complicated, it could
be
107minutes. This is easy to understand in it's self. Yet I need a
formulae
that would convert the 107 (which is a general number with no
decimal
places)
into a time which should be 1 Hour 47 minutes

This formula will do that...

=TEXT(A1/1440,"[h] ""hours"" mm ""minutes""")

where A1 is assumed to have your 107 minute result.

Rick

The cell that gives the 107 which is (k109) has the following formulae in it
=SUM(K99:K108) its a bisic number cell with no decimal places.

"Rick Rothstein (MVP - VB)" wrote:

I think you are going to have to give us some additional information. If
there is a formula in the cell with the 107 in it, copy/paste it into a
response to us. Also, tell us exactly what is displayed in the cell (and
what side of the cell it is on... left or right side). If there is a formula
in the cell, tell us what is in any referenced cells (that is, if your
formula uses C5 in it, tell us what is in C5). Right-click the cell and
select Format Cells from the popup menu... what item in the Category list
(on the Number tab) is selected? If Custom, tell us what custom format
string is shown in the Type field. Oh, and is this cell part of a merged set
of cells? You could also tell us anything else you might have done "out of
the ordinary" to the cell.

Better yet would be if you could put the spreadsheet up on a webpage
somewhere so that we could download it and look at it directly (of course,
if you do this, tell us what cell or cells we should be looking at).

Rick


"James" wrote in message
...
Whatever i try doesn't give me what i want.
"Rick Rothstein (MVP - VB)" wrote:

Wouldn't the A1/1440 part of my formula convert a "text number" into a
real
number in order to perform the division?

Rick


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
It sounds as if A1 doesn't contain a number, but instead contains some
form of text. What does =ISNUMBER(A1) show?
--
David Biddulph

"James" wrote in message
...
Thank but that just gives me a reply of #VALUE
Am i doing something wrong in my formulae?
I copied and paste yours and changed the cell reference but it still
dunna
work!!!
Grrrrr pulling my hair out here!


"Rick Rothstein (MVP - VB)" wrote:

At the end of the day it becomes a bit more complicated, it could
be
107minutes. This is easy to understand in it's self. Yet I need a
formulae
that would convert the 107 (which is a general number with no
decimal
places)
into a time which should be 1 Hour 47 minutes

This formula will do that...

=TEXT(A1/1440,"[h] ""hours"" mm ""minutes""")

where A1 is assumed to have your 107 minute result.

Rick

I've got no where to post them to have a look but i' happily email them to
some-one to have a gander! I can do basic formulaes but i'm stuggling with
this one!

"James" wrote:

The cell that gives the 107 which is (k109) has the following formulae in it
=SUM(K99:K108) its a bisic number cell with no decimal places.

"Rick Rothstein (MVP - VB)" wrote:

I think you are going to have to give us some additional information. If
there is a formula in the cell with the 107 in it, copy/paste it into a
response to us. Also, tell us exactly what is displayed in the cell (and
what side of the cell it is on... left or right side). If there is a formula
in the cell, tell us what is in any referenced cells (that is, if your
formula uses C5 in it, tell us what is in C5). Right-click the cell and
select Format Cells from the popup menu... what item in the Category list
(on the Number tab) is selected? If Custom, tell us what custom format
string is shown in the Type field. Oh, and is this cell part of a merged set
of cells? You could also tell us anything else you might have done "out of
the ordinary" to the cell.

Better yet would be if you could put the spreadsheet up on a webpage
somewhere so that we could download it and look at it directly (of course,
if you do this, tell us what cell or cells we should be looking at).

Rick


"James" wrote in message
...
Whatever i try doesn't give me what i want.
"Rick Rothstein (MVP - VB)" wrote:

Wouldn't the A1/1440 part of my formula convert a "text number" into a
real
number in order to perform the division?

Rick


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
It sounds as if A1 doesn't contain a number, but instead contains some
form of text. What does =ISNUMBER(A1) show?
--
David Biddulph

"James" wrote in message
...
Thank but that just gives me a reply of #VALUE
Am i doing something wrong in my formulae?
I copied and paste yours and changed the cell reference but it still
dunna
work!!!
Grrrrr pulling my hair out here!


"Rick Rothstein (MVP - VB)" wrote:

At the end of the day it becomes a bit more complicated, it could
be
107minutes. This is easy to understand in it's self. Yet I need a
formulae
that would convert the 107 (which is a general number with no
decimal
places)
into a time which should be 1 Hour 47 minutes

This formula will do that...

=TEXT(A1/1440,"[h] ""hours"" mm ""minutes""")

where A1 is assumed to have your 107 minute result.

Rick

You can send it to me... just remove the NOSPAM stuff out of my email
address.

By the way, I don't remember if you posted this or not... what version of
Excel are you using?

Rick


"James" wrote in message
...
I've got no where to post them to have a look but i' happily email them to
some-one to have a gander! I can do basic formulaes but i'm stuggling
with
this one!

"James" wrote:

The cell that gives the 107 which is (k109) has the following formulae in
it
=SUM(K99:K108) its a bisic number cell with no decimal places.

"Rick Rothstein (MVP - VB)" wrote:

I think you are going to have to give us some additional information.
If
there is a formula in the cell with the 107 in it, copy/paste it into a
response to us. Also, tell us exactly what is displayed in the cell
(and
what side of the cell it is on... left or right side). If there is a
formula
in the cell, tell us what is in any referenced cells (that is, if your
formula uses C5 in it, tell us what is in C5). Right-click the cell and
select Format Cells from the popup menu... what item in the Category
list
(on the Number tab) is selected? If Custom, tell us what custom format
string is shown in the Type field. Oh, and is this cell part of a
merged set
of cells? You could also tell us anything else you might have done "out
of
the ordinary" to the cell.

Better yet would be if you could put the spreadsheet up on a webpage
somewhere so that we could download it and look at it directly (of
course,
if you do this, tell us what cell or cells we should be looking at).

Rick


"James" wrote in message
...
Whatever i try doesn't give me what i want.
"Rick Rothstein (MVP - VB)" wrote:

Wouldn't the A1/1440 part of my formula convert a "text number" into
a
real
number in order to perform the division?

Rick


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
It sounds as if A1 doesn't contain a number, but instead contains
some
form of text. What does =ISNUMBER(A1) show?
--
David Biddulph

"James" wrote in message
...
Thank but that just gives me a reply of #VALUE
Am i doing something wrong in my formulae?
I copied and paste yours and changed the cell reference but it
still
dunna
work!!!
Grrrrr pulling my hair out here!


"Rick Rothstein (MVP - VB)" wrote:

At the end of the day it becomes a bit more complicated, it
could
be
107minutes. This is easy to understand in it's self. Yet I
need a
formulae
that would convert the 107 (which is a general number with no
decimal
places)
into a time which should be 1 Hour 47 minutes

This formula will do that...

=TEXT(A1/1440,"[h] ""hours"" mm ""minutes""")

where A1 is assumed to have your 107 minute result.

Rick

Excell 2003


"Rick Rothstein (MVP - VB)" wrote:

You can send it to me... just remove the NOSPAM stuff out of my email
address.

By the way, I don't remember if you posted this or not... what version of
Excel are you using?

Rick


"James" wrote in message
...
I've got no where to post them to have a look but i' happily email them to
some-one to have a gander! I can do basic formulaes but i'm stuggling
with
this one!

"James" wrote:

The cell that gives the 107 which is (k109) has the following formulae in
it
=SUM(K99:K108) its a bisic number cell with no decimal places.

"Rick Rothstein (MVP - VB)" wrote:

I think you are going to have to give us some additional information.
If
there is a formula in the cell with the 107 in it, copy/paste it into a
response to us. Also, tell us exactly what is displayed in the cell
(and
what side of the cell it is on... left or right side). If there is a
formula
in the cell, tell us what is in any referenced cells (that is, if your
formula uses C5 in it, tell us what is in C5). Right-click the cell and
select Format Cells from the popup menu... what item in the Category
list
(on the Number tab) is selected? If Custom, tell us what custom format
string is shown in the Type field. Oh, and is this cell part of a
merged set
of cells? You could also tell us anything else you might have done "out
of
the ordinary" to the cell.

Better yet would be if you could put the spreadsheet up on a webpage
somewhere so that we could download it and look at it directly (of
course,
if you do this, tell us what cell or cells we should be looking at).

Rick


"James" wrote in message
...
Whatever i try doesn't give me what i want.
"Rick Rothstein (MVP - VB)" wrote:

Wouldn't the A1/1440 part of my formula convert a "text number" into
a
real
number in order to perform the division?

Rick


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
It sounds as if A1 doesn't contain a number, but instead contains
some
form of text. What does =ISNUMBER(A1) show?
--
David Biddulph

"James" wrote in message
...
Thank but that just gives me a reply of #VALUE
Am i doing something wrong in my formulae?
I copied and paste yours and changed the cell reference but it
still
dunna
work!!!
Grrrrr pulling my hair out here!


"Rick Rothstein (MVP - VB)" wrote:

At the end of the day it becomes a bit more complicated, it
could
be
107minutes. This is easy to understand in it's self. Yet I
need a
formulae
that would convert the 107 (which is a general number with no
decimal
places)
into a time which should be 1 Hour 47 minutes

This formula will do that...

=TEXT(A1/1440,"[h] ""hours"" mm ""minutes""")

where A1 is assumed to have your 107 minute result.

Rick