Forum Discussion
Jeff_Weinacker
Apr 26, 2021Copper Contributor
Hyper links in excel broken with office 365 update
Ok.. I maintain a database with links to quote files, correspondence, data sheets, and part numbers in a master file using excel. The file currently has over 5000 hyperlinks. This morning my compute...
HansVogelaar
Jun 15, 2023MVP
Let's say you have such values in D2 and down.
In E2:
=INT(D2)/24+MOD(D2,1)/14.4
Format E2 as time, then fill down.
KymberliMDA
Jun 15, 2023Copper Contributor
But the time as a decimal 3.24 would be more like 3:15 or 3:14 and not 3:24, so that doesn't work