MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### Excel calcutions using date/timestamps

• Follow

```I'm trying to write an excel formula to calculate the performance improvement
using timestamps.

Process A took 2hrs, 20 min, 9 sec  expressed as  2:20:09
Process B took 1hr, 12min, 28 sec  expressed as 1:12:28
Difference is calculated as a-b = 1:07:41

How do I calculate the Process B percentage improvement in processing time
using these timestamps?
```
 0
Reply Utf 4/14/2010 5:55:01 PM

```assume 2:20:09 is in cell A1
assume 1:12:28 is in cell B1
=(B1 - A1) / A1
and format for %
This would give -48% or a 48% decrease in time from 2:20:09 to 1:12:28.

--
Hope this helps.
If it does, please click the Yes button.
Gary Brown

"ghl" wrote:

> I'm trying to write an excel formula to calculate the performance improvement
> using timestamps.
>
> Process A took 2hrs, 20 min, 9 sec  expressed as  2:20:09
> Process B took 1hr, 12min, 28 sec  expressed as 1:12:28
> Difference is calculated as a-b = 1:07:41
>
> How do I calculate the Process B percentage improvement in processing time
> using these timestamps?
```
 0
Reply Utf 4/14/2010 6:06:01 PM

1 Replies
370 Views

(page loaded in 0.044 seconds)

Similiar Articles:

8/21/2012 6:35:28 AM