Percent in Time formula

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?
 
P

Paul Corrado

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
 
M

Mike

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...
 
M

Mike

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.
 
A

adam

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.
 
A

adam

well, it would seem that the reports I am being delivered are screwy, so
thatnks for your help guys....
 

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

Top