Hi,

I have a spreadsheet that currently uses a number of minutes (eg 60 or 90) to make a calculation. In a different cell, I have the same value but in time format (01:00:00 or 01:30:00) to make a different calculation.

I would like to only have to enter the number of minutes and have the time value to reflect this. At present I have to manually enter both values.

Is there a way I can convert 60 to 01:00:00 or 90 to 01:30:00 or any other equivalent of minutes to the corresponding hh:mm:ss?

Many thanks,
Pie