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
1 Reply
- 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
