can i convert text to time format ??????

C

compie1

hi guys & girls!
i have a huge problem, got a sheet with times example 03:01:57 but the
previous one copied it as text but i need to make the sum of them and i
can not convert to time anymore can someone help me please !!!!!

kind regards,

Tom Van Compernolle
 
E

Earl Kiosterud

Tom,

=TIMEVALUE(A1)

Earl Kiosterud
Mvpearl omitthisword at verizon period net.
 

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

Excel does not accept text format! 0
I have lost 6 months work, how can i get my file back 1
Over time? 4
Converting text format of time/date into Excel time/date for subtr 5
ASK Field Formatting 1
How do I install Microsoft Equation 3.0 back to Office 365? 0
Adding up time values 13
How to Convert 24/03/2010 as text into 03/24/2010 date format 3

Top