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