Posted to microsoft.public.excel.misc

Barb Reinhardt Barb Reinhardt is offline

external usenet poster

Posts: 3,355

Figuring our % difference between two times

=(NewTime - OldTime)/OldTime

Format as %

"JM" wrote:

If I have a process that used to take 5 hours 30 and now it takes 4 hours 10
minutes, how do I create a formula to calculate the % difference?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate difference in Times	Darren	Excel Discussion (Misc queries)	13	April 16th 07 12:02 PM
Caluculate difference between two times	BRO	Excel Discussion (Misc queries)	7	January 30th 07 10:27 PM
Difference between two times	Jester	Excel Discussion (Misc queries)	4	August 31st 06 01:36 PM
Difference in Times	bcbjork	Excel Discussion (Misc queries)	6	August 27th 05 03:42 PM
Converting from time format to decimal and figuring the difference	Steve Williams	Excel Discussion (Misc queries)	1	July 30th 05 10:10 PM

All times are GMT +1. The time now is 04:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us