Excel Time Formatting Issue

[laradio]

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.

[Pepe Le Mokko]

Copy Paste and custom format as mm:ss:00 ?

[laradio]

unfortunately that didnt work either

[FDibbins]

What you need to understand about dates and times in excel is…

a date is just a number representing the number of days passed since 1/1/900...and then formatted in a way that we recognize as a date. So, for instance, today (Wed 11 Mar 2020) is actually 43901

Time is actually a decimal part of 1 (day), so 06:00 AM is 0.25, 12 noon is 0.5 and 18:00 (or 6 PM) is 0.75

With that said, you will never find eg 35:44:00,you would need to search for something like 0.488888889

However, Time can go out to a lot of decimal places, your sample is actually 0.488888888888889000000 (excel only goes out to 16 significant decimals though)
Soooo now you have the problem of deciding on what level of accuracy you want, then rounding your time values to somehting you can use in a vlookup

[Pepe Le Mokko]

Post a sample sheet ( see yellow banner)

[laradio]

I attached an example.

[Sam Capricci]

if you want it the same, use custom format and [h]:mm:ss
but just because they didn't look the same they are, if you look at B2 it is 1/1/1900 1:44:00 AM and the vlookup formatted as general returned 1.072 but using built in date format of 3/14/12 1:30 PM (from the format list) it returns 1/1/00 1:44 AM which looks much closer to what is in B2 when you click on the cell.
and if you use the custom format of mm/dd/yyyy hh:mm:ss it will look almost identical to what is in B2 but it will not show as 25:44:00 unless you use the format at the top of this post.