Thread: Change time format from :0 to 0:0
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Change time format from :0 to 0:0
=TIME(0,MID(A1,2,2),RIGHT(A1,2))

fomat cells as h:mm:ss
copy down

"Donald B" wrote:

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