Excel - Date/Time formating to text problem

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
 
B

Brad Yundt

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Date/Time formating to text problem 1
Excel - convert dates to text but appear as a date format 6
Whats going on with this column display? 1
Auto enter date 6
Conditional Formatting 1
Excel Time Calculation / Conversion 1
Date format problem 1
Formatting Text to Numbers for Dates 2

Top