Percentage of Hours

[Jenn L]

Dear All

Can you help me out with some simple formula please!
An operation should normally take 3 hours to do.
I have a start and finish time and I can calculate the number of hours
taken by puttng in the date and time i.e. "10/05/04 14:00" in A1 and
"10/05/04 16:00" in A2. A2-A1 will give me 2:00 in A3
How can I then calculate what percentage of the 3 hours it has taken,
and enter the result in A4, in this example approx 66%?
Thanks for your help in advance.

Jenn

 

[Frank Kabel]

Hi
try
=(A2-A1)/(3/24)
and format this cell as percentage

 

[Trevor Shuttleworth]

Jenn

A2-A1 will give you a "time" which is actually a part of 24 hours

So, one way:

Use =(A2-A1)*24 and format as general to get a real number

Then divide A3 by 3 and format as a percentage with two decimal places.

I'm sure there are lots of other ways !

Regards

Trevor

 

[Guest]

Here's how I did it

A1 has: 10/5/04 3:0
A2 has: 10/5/04 5:0
A3 has: =(A2-A1) * 2
A4 has: =A3/

I also formatted cell A3 as "Number" (Go to Format/Format Cells and select number

This will produce 0.66 in cell A4, which you can click on the % button to format at 67

The reason why you have to include the "* 24" in the formula for A3, is because when you subtract one date from another, then display that value as a number, it will show you the number of DAYS in the difference. If your desire is to work in hours, just throw the "* 24" to convert to hours. Alternatively, you could have changed the formula in A4 to "=A3/(3/24)" to keep everything in days...

Hope that helps

Dante Gagn
Software Design Engineer/Tes
Developer Divisio
Microsoft Corporatio

This posting is provided "AS IS" with no warranties, and confers no rights.