Forum Discussion
Changing from day/hour/minute to a number
Hi,
I have a large column of data from a databank giving the time needed to complete a report, given as "1 D 09:43:36", and I need to transform that to a number, i.e. 1.4 (days) and to calculate th...
Hi,
Better with Power Query but if with formulas could be like
=VALUE(LEFT(A1,SEARCH("D",A1)-1))+VALUE(RIGHT(A1,LEN(A1)-SEARCH("D",A1)))
to convert
