use displayed value in calculation
 

quick question -

if I perform a simple calculation of =(a1+b1) in the m1 cell, and then
need to use that result in another calculation in the n1 cell
=(m1*3.14), why do I get a value of 0.00 returned?



michae

use displayed value in calculation
 

What values are in cells A1 and B1?
A small number, showing two decimal places, could display as 0.00

michael wrote:
quick question -

if I perform a simple calculation of =(a1+b1) in the m1 cell, and then
need to use that result in another calculation in the n1 cell
=(m1*3.14), why do I get a value of 0.00 returned?



michae



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

use displayed value in calculation
 

What is result in M1 cell?


"michael" wrote in message
oups.com...
quick question -

if I perform a simple calculation of =(a1+b1) in the m1 cell, and then
need to use that result in another calculation in the n1 cell
=(m1*3.14), why do I get a value of 0.00 returned?



michae

use displayed value in calculation
 

What is result in M1 cell?


"michael" wrote in message
oups.com...
quick question -

if I perform a simple calculation of =(a1+b1) in the m1 cell, and then
need to use that result in another calculation in the n1 cell
=(m1*3.14), why do I get a value of 0.00 returned?



michae

use displayed value in calculation
 

What is result in M1 cell?


"michael" wrote in message
oups.com...
quick question -

if I perform a simple calculation of =(a1+b1) in the m1 cell, and then
need to use that result in another calculation in the n1 cell
=(m1*3.14), why do I get a value of 0.00 returned?



michae

use displayed value in calculation
 

Debra Dalgleish wrote:
What values are in cells A1 and B1?
A small number, showing two decimal places, could display as 0.00


the values in cells a1 and b1 are formatted ( hh:mm:ss ) time values.

use displayed value in calculation
 

Mladen_Dj wrote:
What is result in M1 cell?

I hope I am answering your question properly.

the result found in the m1 cell is based on the equation =(b1-a1). the
a1, b1 and m1 cells are time formatted ( hh:mm:ss ).

if a1 = 08:00:00 and b1 = 08:23:37, the displayed value in m1 would be
00:23:37. my end goal is to covert this value to a decimal in the n1
cell ( =(m1*.017) which would provide 0.39729 or .40, as the cell is
formatted to two decimal places ).

use displayed value in calculation
 

Hi Michael

Time is stored in Excel as fractions of a day (24 hours).
Try =(B1-A1)*24
Format your cell as General, and you should get your expected result.

Regards

Roger Govier


michael wrote:
Mladen_Dj wrote:

What is result in M1 cell?


I hope I am answering your question properly.

the result found in the m1 cell is based on the equation =(b1-a1). the
a1, b1 and m1 cells are time formatted ( hh:mm:ss ).

if a1 = 08:00:00 and b1 = 08:23:37, the displayed value in m1 would be
00:23:37. my end goal is to covert this value to a decimal in the n1
cell ( =(m1*.017) which would provide 0.39729 or .40, as the cell is
formatted to two decimal places ).

use displayed value in calculation
 

Roger Govier wrote:
Hi Michael

Time is stored in Excel as fractions of a day (24 hours).
Try =(B1-A1)*24
Format your cell as General, and you should get your expected result.

Regards

Roger Govier


Roger,

SWEET!!! thanks for the heads up. does exactly what I want ( after I
figured out how to apply the round() function to the value as well ).

onto some conditionals now.



michael

use displayed value in calculation
 

Mladen_Dj wrote:
What is result in M1 cell?


the a1 and b1 cells are the beginning and ending time values that use
the hh:mm:ss format.

so a1 could read 08:00:00 and b1 could read 08:23:37. the value of the
m1 cell is determined using =(b1-a1) to display a formatted time value
of 00:23:37 in the m1 cell.

the n1 cell would be used to convert the m1 displayed value to a
decimal, =(m1*.017), which would then display 0.39729 or .40 as I have
the cell set to round up to two decimal places.

to which my asking for help as the value being displayed in the n1 cell
is 0.00.




michael

use displayed value in calculation
 

I am not sure where your expected result of 0.39729 comes from. 1.7% of of
23 minutes and 37 seconds is about 24.09 seconds, or about 0.4015 minutes.

Roger's suggestion that 23 minutes and 37 seconds is 0.393611 of an hour is
close, but still not equal to your expected result.

Jerry

"michael" wrote:

Mladen_Dj wrote:
What is result in M1 cell?

I hope I am answering your question properly.

the result found in the m1 cell is based on the equation =(b1-a1). the
a1, b1 and m1 cells are time formatted ( hh:mm:ss ).

if a1 = 08:00:00 and b1 = 08:23:37, the displayed value in m1 would be
00:23:37. my end goal is to covert this value to a decimal in the n1
cell ( =(m1*.017) which would provide 0.39729 or .40, as the cell is
formatted to two decimal places ).