View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Lauren Giles Lauren Giles is offline
external usenet poster
 
Posts: 70
Default Do anyone know how to covert 912:30:44 into seconds

In other words, multiply.

Multiply the hours by 60 (60 minutes in an hour) and multipy the result by
60 again (60 seconds in a minute). Put that number aside. Multiply the
minutes by 60 (agian, 60 seconds in a minute). Hold on to that number. Now,
take all three numbers (including the numbers you already had for seconds)
and add them together.

Ah, the magic of maths.

"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