Seonds to time value

  • Thread starter Thread starter tojo107
  • Start date Start date
T

tojo107

I import data into Excel - the time comes in as seconds -
example - 3 minutes looks like 180. How do I get Excel
to change this to a time value - 03:00 in this case?

Thanks in advance for your help.

Tom
 
You must log in or register to reply here.

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

please help.is it possible re-edit macro to convert text like1530-2200 to time format automatically? 1
i want to convert decimals into time format 3
Time Stored as Text 3
Time calculations 3
Time Values As Numbers 3
pasting time from html 12
Convert Min & Hrs to Min in Decimal 6
Calculating Hours, Minutes and Seconds 6

Back
Top