Converting to minutes and seconds
XL stores times as fractional days, so if you want a true XL time,
you'll need to divide by 24*60*60:
A1: 23
A2: =A1/86400 === 0:00:23
In article ,
JaB wrote:
At the moment, the figure expressed is in seconds but displayed just as a
general number.
|