ExcelBanter - Figuring our % difference between two times

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Figuring our % difference between two times (https://www.excelbanter.com/excel-discussion-misc-queries/142462-figuring-our-%25-difference-between-two-times.html)

Figuring our % difference between two times

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?

Barb Reinhardt

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?

All times are GMT +1. The time now is 02:48 PM.