J
JE McGimpsey
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
(the brackets prevent roll-over to minutes & hours).
tsp <[email protected]> wrote:
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
(the brackets prevent roll-over to minutes & hours).
tsp <[email protected]> wrote: