Percent in Time formula

  • Thread starter Thread starter adam
  • Start date Start date
A

adam

I have a list of tasks, and the time these tasks were done in, ie:

task a 00:43
task b 15:45
and so on...

Total: 256:25

The format of the times is HH:MM

What I need to do is create a diagram with the percentages that each task
took. I have tried to use a formula to break the HH:MM into minutes, which
would simplfy the whole thing, however nothing Ive tried has worked...

Any Ideas?
 
Adam,

Just divide the time spent on each task by the total time to get the % and
then use the chart wizard to make your chart.

PC
 
A B C
1 task_a 0:43 0.3%
2 task_b 15:45 6.1%
3 task_c 239:57 93.6%
4 Total: 256:25 100.0%

B4: =SUM(B1:B3)
C1: =B1/B$4

I do not understand why nothing you'd tried has worked...
 
To get a percentage, simply use =task a/Total and format
the cell as a percent. It doesn't matter what the format
is used for the times (can be HH:MM, or MM, or decimal
values), as long as the total and individual times use the
same format you don't need to do any convertions.
 
I still get a #Value error

Adam


Mike said:
To get a percentage, simply use =task a/Total and format
the cell as a percent. It doesn't matter what the format
is used for the times (can be HH:MM, or MM, or decimal
values), as long as the total and individual times use the
same format you don't need to do any convertions.
Click to expand...
 
well, it would seem that the reports I am being delivered are screwy, so
thatnks for your help guys....
 
Back
Top