ExcelBanter - HOW DO I CONVERT 12:00:00 to show as o hrs

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - HOW DO I CONVERT 12:00:00 to show as o hrs (https://www.excelbanter.com/excel-discussion-misc-queries/145564-how-do-i-convert-12-00-00-show-o-hrs.html)

Trevor

HOW DO I CONVERT 12:00:00 to show as o hrs

i have a start time in hrs and mins 12:00:00
how can this show up as 00:00

All times are GMT +1. The time now is 10:40 PM.