Thread: Change time format from :0 to 0:0
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Donald B[_2_] Donald B[_2_] is offline
external usenet poster
  
Posts: 7
Default Change time format from :0 to 0:0
I have tons of times in this format:
:42:01
:02:58
:04:45
:25:13

and need to change to:

0:42:01
0:02:58
0:04:45
0:25:13

Pls help...
tia
Donald

Reply With QuoteReply With Quote