Hi Laurie!

As long as both cells are in numeric form or both in time form.

=A2/A1
Format as a percentage

You problem is if you have one cell in time form and the other as
numeric.

A1: 00:5:00
A2 150

=A2/A1
Returns: 4320000%

You need to convert the time form to seconds:

=A2/(A1*24*60*60)
Returns 50%

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.