Endtime is a column(named Range) with time entries, StartTime(another named
Range) column with time entries and i need to be able to subtract the end
time from the start time and display the result in a separate colum

have tried to do it with named ranges but the resulting number is an
unrecognizable decimal number

I have been able to do it with absolute cell ranges but there are(will be)
many many rows where it would not be practical to have to manually enter the
formula per row and the person entering the information needs to be
restricted to data entry only (no entering formulas)