Calculating percentage of time

[NCK]

Hi,

I want to calculate the percentage of total time which a cell takes up in a
row of cells. For example, elements 1 to 3 with 1 = 00:20:00, 2 = 02:00:00,
3 = 01:00:00. What I'd like to do is to sum() these elements and calculate
the percentage of each by "cell x = cell x value / sum total * 100". Sadly
this does not work. I could express the problem in minutes, but this would
be defeatest!

Cheers

N.

 

[Jerry W. Lewis]

What do you mean "this does not work"? With your times in A1:A3,
=A1/SUM($A$1:$A$3)*100
returns 10, and the other 2 return 60 and 30. That looks like it works
to me.

Possibly there is more information in the cells than just the time?
Format them as a date with time. If they are on different dates, that
might be the source of your problem. Excel date/time values are stored
as the number of days since 1900 plus the time as a decimal fraction
(e.g. 1:30pm is 13/24+30/60/24) = 0.5625). Therefore arithmetic on
dates/times should work just fine, so long as it is formatted appropriately.

Jerry