Percentage of increase/decrease for time

Hello,

Can someone please tell me the best way to calculate the percentage of increase/decrease for time increments. i.e. What is the % of increase from 04:40 to 04:50

I am thinking that I might have to break it into seconds first? Really not sure but the answers I am getting from the usual (b-a)/a is showing strange numbers that I dont feel are correct (with formatting the cells for time and also tried general)

Please help, I have a report due at Noon

Ben

Hello
Hope it's not too late! Try the following formula:

=(MOD(B1,1)-MOD(A1,1))/(MOD(A1,1))

Here your times would be in cells A1 and B1. Format the formula cell to Percentage. Decrease will show as (-)minus.

Hope this helps.

DBY