Hours and minutes display as date in formula box
Hi Dave,
One way is to apply the custom format h:mm to the cell(s) and type an
apostrophe (') before the value eg '93:11. The apostrophe appears in
the formula bar but not in the cell, and you will be able to do
calculations this way too.
To apply the format go FormatCellsNumberCustom then type h:mm in
the Type: box.
Ken Johnson
|