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 ).
|