Forum Discussion
Number conversion to time
Hello, I have exhausted all avenues and cannot find a solution. I have tried numerous formulaes from internet searches and non have worked.
My issue is this:
I have a column called MINUTES which will have a number like 30, 15, 120 , 55 etc.
I need a formulae which will take the number and convert it to time.
So 30 would = 0:30
15 = 0:30
120=. 2:00
Is there a formulae that can do this for me?
My issue is this:
I have a column called MINUTES which will have a number like 30, 15, 120 , 55 etc.
I need a formulae which will take the number and convert it to time.
So 30 would = 0:30
15 = 0:30
120=. 2:00
Is there a formulae that can do this for me?
No RepliesBe the first to reply