Forum Discussion
convert a time (say, 1:45) to a decimal number - and vice versa.
I tried to use various functions, eg. TIME - but only get error messages. There's something I don't understand! Can you show me? - Jim
Hello, assuming you have
1:45 in cell A1
In cell B1, execute A1*24 for hours
A1*1440 for minutes
A1*86400 for seconds
1:45 in cell A1
In cell B1, execute A1*24 for hours
A1*1440 for minutes
A1*86400 for seconds