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

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

If you want it to show as 00:00 you could subtract 12 hours, and then format
as hh:mm

If, however, you format the cell as mm:ss you don't need to subtract the 12
hours.
--
David Biddulph

"Trevor" wrote in message
...
i have a start time in hrs and mins 12:00:00
how can this show up as 00:00

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

Thanks for the reply
much appreciated


"David Biddulph" wrote:

If you want it to show as 00:00 you could subtract 12 hours, and then format
as hh:mm

If, however, you format the cell as mm:ss you don't need to subtract the 12
hours.
--
David Biddulph

"Trevor" wrote in message
...
i have a start time in hrs and mins 12:00:00
how can this show up as 00:00