View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default Do anyone know how to covert 912:30:44 into seconds

1/24 is correct, 1/60 should actually be 1/3600.

In other words if you've got a cell containing 912:30:44 formatted as time
(which in Excel's terms is as a number of days), then use the formula
=A1*24*3600 and format the result as General (or number).
--
David Biddulph

"mbasensation" wrote in message
...
Hi Don,

I'm new at this so below really doesn't mean much to me. Can you please
help me by typying out what 1/24 and 1/60 should actuallly be?

"Don Guillett" wrote:

An hour is 1/24 th of a day and a second is 1/60 th of an hour.

--
Don Guillett
SalesAid Software

"mbasensation" wrote in message
...
Hello all, I need to covert 912:30:44 into seconds. T