
7th January 2005, 10:35 AM
|
|
Member
|
|
Join Date: Jan 1970
Location: Western Australia
Posts: 3,403
|
|
Brave Chief
Hey mate i found a nice solution to your problem with the time formating if you are interested
=SUBSTITUTE(A1,":",".")/-86400
then set formating to custome ss.00
|