enter a time into a cell, have the cell show two times the entry
The cell would have a time format of 00:00:00 or 00:00.
If one entered 01:00:00 into the cell, the cell would show 02:00:00.
If one entered 00:00:32 into the cell, the cell would show 00:01:04.
--
johnp
|