Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 ). |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 ). |
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#11
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 ). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use displayed value, not stored value? | Excel Worksheet Functions | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Function Formula is displayed not results | Excel Worksheet Functions |