View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
SteveW SteveW is offline
external usenet poster
 
Posts: 9
Default Converting hh:mm:ss to seconds only

Cell contains time as fraction of a day

So if A1 = time
use =A1*24*60*60

Steve

On Tue, 27 Feb 2007 09:10:00 -0000, kippers
wrote:

Hi,

Just wondered if anyone could advise me on the easiest way to convert a
value in a cell formated as hh:mm:ss into seconds only i.e. 00:01:30
would
equal 90.

Cheers,