S
sorenwhite
HI if anyone can help at all.
in the attached file I have taken the difference between two date cell
and formatted the output to represent minutes by formatting with (
[h]:mm ) and multiplying by 60. however when I want to take
percentage of this cell with resect to a normal number cell, the answe
is incorrect.
Is there any way to take the output of the date cell as text value, no
as the numerical time format?
thanks for your help
Sore
Attachment filename: time issue.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=56228
in the attached file I have taken the difference between two date cell
and formatted the output to represent minutes by formatting with (
[h]:mm ) and multiplying by 60. however when I want to take
percentage of this cell with resect to a normal number cell, the answe
is incorrect.
Is there any way to take the output of the date cell as text value, no
as the numerical time format?
thanks for your help
Sore
Attachment filename: time issue.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=56228