Is there a formula that will convert h:mm:ss into seconds?
A formula:
Since XL stores times as fractional days, you can multiply by the number
of seconds in a day:
=A1*86400
If you only want to display seconds, you can use
Format/Cells/Number/Custom [s]
(the brackets prevent roll-over to minutes & hours).
In article ,
tsp wrote:
|