Histograms

[watermt]

I'm working on a spreadsheet that is used to collect data (in the [hh]:mm
format) and when I go to put the data rnage into a Histogram I get a message
stating the following:

Histogram - Input range contains non-numeric data.

Can someone help me with this? Do I need to conver the times to a decimal
format?

 

[Bernard Liengme]

If the items are 'real times' then they are already numeric.
If one of the time values is in B2 what does the formula =ISNUMBER(B2)
return?
best wishes

 

[watermt]

False

If the items are 'real times' then they are already numeric.
If one of the time values is in B2 what does the formula =ISNUMBER(B2)
return?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

I'm working on a spreadsheet that is used to collect data (in the [hh]:mm
format) and when I go to put the data rnage into a Histogram I get a
message
stating the following:

Histogram - Input range contains non-numeric data.

Can someone help me with this? Do I need to conver the times to a decimal
format?

 

[Bernard Liengme]

Then you must replace all these values by real time values by retyping them.
If there are more than 20, send me a file and I will see if a formula is
possible
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

False

If the items are 'real times' then they are already numeric.
If one of the time values is in B2 what does the formula =ISNUMBER(B2)
return?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

I'm working on a spreadsheet that is used to collect data (in the
[hh]:mm
format) and when I go to put the data rnage into a Histogram I get a
message
stating the following:

Histogram - Input range contains non-numeric data.

Can someone help me with this? Do I need to conver the times to a
decimal
format?

 

[watermt]

Yes, there are 137 values in two worksheets in the workbook. What is your
email address to send the file?

Then you must replace all these values by real time values by retyping them.
If there are more than 20, send me a file and I will see if a formula is
possible
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

False

If the items are 'real times' then they are already numeric.
If one of the time values is in B2 what does the formula =ISNUMBER(B2)
return?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

I'm working on a spreadsheet that is used to collect data (in the
[hh]:mm
format) and when I go to put the data rnage into a Histogram I get a
message
stating the following:

Histogram - Input range contains non-numeric data.

Can someone help me with this? Do I need to conver the times to a
decimal
format?

 

[Bernard Liengme]

remove TRUENORTH.

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

Yes, there are 137 values in two worksheets in the workbook. What is your
email address to send the file?

Then you must replace all these values by real time values by retyping
them.
If there are more than 20, send me a file and I will see if a formula is
possible
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

False

:

If the items are 'real times' then they are already numeric.
If one of the time values is in B2 what does the formula =ISNUMBER(B2)
return?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

I'm working on a spreadsheet that is used to collect data (in the
[hh]:mm
format) and when I go to put the data rnage into a Histogram I get a
message
stating the following:

Histogram - Input range contains non-numeric data.

Can someone help me with this? Do I need to conver the times to a
decimal
format?

 

[watermt]

I'm not sure what remove TRUENORTH refers to?

remove TRUENORTH.

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

Yes, there are 137 values in two worksheets in the workbook. What is your
email address to send the file?

Then you must replace all these values by real time values by retyping
them.
If there are more than 20, send me a file and I will see if a formula is
possible
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

False

:

If the items are 'real times' then they are already numeric.
If one of the time values is in B2 what does the formula =ISNUMBER(B2)
return?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

I'm working on a spreadsheet that is used to collect data (in the
[hh]:mm
format) and when I go to put the data rnage into a Histogram I get a
message
stating the following:

Histogram - Input range contains non-numeric data.

Can someone help me with this? Do I need to conver the times to a
decimal
format?

 

[Bernard Liengme]

When I post to newsgroups my email address show with TRUENORTH in it. Can
you not see my address as you read this message?
Alternative,Click the link in this message and you will find my real email
address
If I type my email address here I will get tooooo much spam!
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

I'm not sure what remove TRUENORTH refers to?

remove TRUENORTH.

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

Yes, there are 137 values in two worksheets in the workbook. What is
your
email address to send the file?

:

Then you must replace all these values by real time values by retyping
them.
If there are more than 20, send me a file and I will see if a formula
is
possible
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

False

:

If the items are 'real times' then they are already numeric.
If one of the time values is in B2 what does the formula
=ISNUMBER(B2)
return?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

I'm working on a spreadsheet that is used to collect data (in the
[hh]:mm
format) and when I go to put the data rnage into a Histogram I
get a
message
stating the following:

Histogram - Input range contains non-numeric data.

Can someone help me with this? Do I need to conver the times to
a
decimal
format?

 

[watermt]

I can not see your address but did as you stated and will send the file in a
few minutes.

Thanks so much!

When I post to newsgroups my email address show with TRUENORTH in it. Can
you not see my address as you read this message?
Alternative,Click the link in this message and you will find my real email
address
If I type my email address here I will get tooooo much spam!
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

I'm not sure what remove TRUENORTH refers to?

remove TRUENORTH.

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

Yes, there are 137 values in two worksheets in the workbook. What is
your
email address to send the file?

:

Then you must replace all these values by real time values by retyping
them.
If there are more than 20, send me a file and I will see if a formula
is
possible
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

False

:

If the items are 'real times' then they are already numeric.
If one of the time values is in B2 what does the formula
=ISNUMBER(B2)
return?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

I'm working on a spreadsheet that is used to collect data (in the
[hh]:mm
format) and when I go to put the data rnage into a Histogram I
get a
message
stating the following:

Histogram - Input range contains non-numeric data.

Can someone help me with this? Do I need to conver the times to
a
decimal
format?

 

[watermt]

Did you receive the Excel file I emailed to you? If so, any suggestions you
may have to offer would be greatly appreciated.

Mike

When I post to newsgroups my email address show with TRUENORTH in it. Can
you not see my address as you read this message?
Alternative,Click the link in this message and you will find my real email
address
If I type my email address here I will get tooooo much spam!
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

I'm not sure what remove TRUENORTH refers to?

remove TRUENORTH.

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

Yes, there are 137 values in two worksheets in the workbook. What is
your
email address to send the file?

:

Then you must replace all these values by real time values by retyping
them.
If there are more than 20, send me a file and I will see if a formula
is
possible
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

False

:

If the items are 'real times' then they are already numeric.
If one of the time values is in B2 what does the formula
=ISNUMBER(B2)
return?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

I'm working on a spreadsheet that is used to collect data (in the
[hh]:mm
format) and when I go to put the data rnage into a Histogram I
get a
message
stating the following:

Histogram - Input range contains non-numeric data.

Can someone help me with this? Do I need to conver the times to
a
decimal
format?

 

[watermt]

Bernard, sorry to bother you but I've not had an email reply from you
regarding my Excel file I emailed to you?

Did you receive it?

Mike