I can't figure out how to create a formula that will change
hours:minute:seconds into a percentage, so that I can analize for how much
time in relationship to the % of an hour was used.
Example a report that is generated displays: 0:15:00 how do I write a
formula to change this number into .25, which would representant .25 of an
hour?

For A1 formatted as HH:MM:SS, then B1 (formatted as %) =Minute(A1)/60 will
give a value of 25%.

Are you only interested in the minutes?

HTH

"Jana" wrote:

I can't figure out how to create a formula that will change
hours:minute:seconds into a percentage, so that I can analize for how much
time in relationship to the % of an hour was used.
Example a report that is generated displays: 0:15:00 how do I write a
formula to change this number into .25, which would representant .25 of an
hour?

Time in Excel is actually stored as a number where the value 1 is equal to a
day, so you would need to do this:
Take the MOD of the number with 1 to make sure you only have the decimal
portion (hours of the day)
Take the resulting value and divide it by "an hour" which is 1/24th of a day
(and dividing by 1/24 is the same as multiplying by 24)
The resulting formula (assuming you have a time in A1) would be:
=MOD(A1,1)*24
To display properly, make sure the format for your formula cell is Number,
not Date or Time.

"Jana" wrote:

I can't figure out how to create a formula that will change
hours:minute:seconds into a percentage, so that I can analize for how much
time in relationship to the % of an hour was used.
Example a report that is generated displays: 0:15:00 how do I write a
formula to change this number into .25, which would representant .25 of an
hour?