Time Format

  • Thread starter Thread starter Donald B
  • Start date Start date
D

Donald B

0:00:01:48
0:00:02:14
0:00:03:03
0:00:03:38
0:00:01:53
0:00:03:07
0:00:05:54

These numbers are imported as a text format. I tried to format cells as
time and custom but no luck. I also tried the 'RIGHT" function. I want to add
these up but been unsuccessful.
Hope I provided enough information.

TIA
Don
 
Try:

=--RIGHT(A1,LEN(A1)-2)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting time...again 2
Time query 9
Problem formatting dates from CSV file 2
Conditional Time Calculation 10
Peak call times/hours 2
separating date and time 5
Break Calculation 1
Adding up time values 11

Back
Top