Excel - Date/Time formating to text problem

  • Thread starter Thread starter sorenwhite
  • Start date Start date
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
 
I assume you are looking for a percentage comparison to
the number of minutes in another cell. If so, multiply
the difference in the date cells by 1440 (the number of
minutes in a day) to get a result in minutes, then divide
that result by your number cell to get a percentage. The
date serial number increments by 1 every 24 hours--which
is why multiplying by 60 didn't work for you.
 
Back
Top