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,
Please try this formula and find it in the attached file:
=LEFT(A1,2)+ROUND((RIGHT(A1,8)),1)