I am downloading an excel workbook online that posts MINUTES like this (35:44:00). I try to use V-look up to copy this time to another sheet, however it's not giving me this exact number (which I need). When I do the Vlook up, its giving me the value of the time. I tried to copy and paste values only in the column-didn't work. I tried using different format cell options, the problem persists.

Does anyone know how I can copy the minute stamp on a sheet without it changing or without me having to manually type the minutes for each line in the workbook?

Any help would be appreciated, thank you.