i have a start time in hrs and mins 12:00:00 how can this show up as 00:00
D David Biddulph Jun 7, 2007 #2 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.
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.
G Guest Jun 13, 2007 #3 Thanks for the reply much appreciated David Biddulph said: 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. Click to expand...
Thanks for the reply much appreciated David Biddulph said: 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. Click to expand...