View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default 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.