If your activity time is expressed in decimal, it should be no problem .
Add a small sample so we can see the formats you are using

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi here is a sample. I guess the time format here is not a percentage.
-- Is there a specified format in Excel or
-- a handy formula to change a time to a percentage?

If i express the time in numerals, the difference shows as "0" = problem

SDD + CollectionActivity UOMUnitsStartFinishElapsed TimeLost TimeHeldSE = activities per hr309844 AFSearch/Locate/edit/statsTitle112:1012:150:050:0020.0Search/Locate/edit/statsTitle112:1912:240:050:00#REF!Search/Locate/edit/statsTitle112:2512:290:04#REF!Search/Locate/edit/statsTitle112:3112:330:02#REF!Search/Locate/edit/statsTitle112:3412:380:04#REF!Search/Locate/edit/statsTitle112:3912:420:03#REF!

and now with incorrect answers...
SDD + CollectionActivity UOMVolumeStartFinishElapsed TimeLost TimeActivity TimeSE = activities per hr309844 ANFAdd/edit/statsItem112:1512:190:040:0421600.0Add/edit/statsItem112:2012:250:050:0517280.0Add/edit/statsItem112:2912:310:020:0243200.0Add/edit/statsItem112:3212:330:010:0186400.0Add/edit/statsItem112:3812:390:010:0186400.0

sorry - the excel spreadsheet didn't copy well into this email.
the time is expressed as a ration, 14:44 14:46 14:47 14:49 etc
I am trying to divide the difference between two times by a number. the difference is expressed as a ratio 0:02 0:03 0:06 etc
it doesn't work.
-- how do i get it to work?
kind regards
tweeter