use displayed value in calculation

  • Thread starter Thread starter michael
  • Start date Start date
M

michael

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
 
What values are in cells A1 and B1?
A small number, showing two decimal places, could display as 0.00
 
Debra said:
What values are in cells A1 and B1?
A small number, showing two decimal places, could display as 0.00
Click to expand...

the values in cells a1 and b1 are formatted ( hh:mm:ss ) time values.
 
Mladen_Dj said:
What is result in M1 cell?
Click to expand...
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 ).
 
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 said:
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
Click to expand...

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
 
Mladen_Dj said:
What is result in M1 cell?
Click to expand...
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
 
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
 
Back
Top