Forum Home
Press F1
Thread ID: 10748	2001-08-10 03:24:00	MS excel 98 time format problem	Guest (0)	Press F1

Post ID	Timestamp	Content	User
16763	2001-08-10 03:24:00	I have got a series of times in the annoying format of hh: mm: ss - the annoying thing is that there are spaces in between the values, and excel can't read them as dates. so like 48 minutes 28 seconds reads as 0: 48: 28 - when i want it to read 00:48:28 anyone one know of a funiction to get rid of these spaces and convert it to the form I want?.. thanks in advance..	Guest (0)
16764	2001-08-10 23:50:00	Goto Format/Cells/Custom scroll down the list and there should be hh:mm:ss. If not enter hh:mm:ss in the Type requester and click OK. HTH	Guest (0)
16765	2001-08-13 00:21:00	nope, that does'nt work, I tried that earlier, because of the spaces in between the values excel does'nt know what format it is. if i could get rid of the sapces witout having to do it by hand for every value that would be good. but thanks anyway	Guest (0)
1