Switch Minutes to Seconds in Excel

October 11, 2009 by vba excel
Filed under: Excel Formulas 
Sponsor

Excel Formulas Switch Minutes to Seconds in Excel [Q]

I have a telephone-report that gives me the number of seconds each
conversation has taken. I want to convert these seconds in a hh:mm:ss format. Is there a function or a formula available in Excel that switch minutes to seconds ?

Excel Formulas Switch Minutes to Seconds in Excel [A]

You can switch minutes to seconds in excel by putting 86400 in a spare cell and copy it, then :

Select your range
Goto Edit>PasteSpecial and click Divide
OK

Format the cells as time, and claer the cell with 86400 in it

  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Google
  • E-mail this story to a friend!
  • Live
  • MisterWong
  • Propeller
  • StumbleUpon
  • Technorati
  • TwitThis
  • YahooMyWeb
  • Print this article!

Rate This Tips:

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 3.00 out of 5)
Loading ... Loading ...


Incoming excel search terms

mss,how to convert minutes to seconds in excel,convert seconds to minutes in excel,how to convert seconds to minutes in excel,excel convert minutes to seconds formula,averaging minutes and seconds in excel,convert minutes to seconds in excel,converting minutes and seconds to minutes in excel,excel convert time to seconds,formula to convert seconds to minutes,how to add minutes and seconds in excel,how to convert time into seconds in excel,how to convert minutes to seconds,,adding minutes and seconds in excel,calculating minutes and seconds excel,calculating minutes and seconds in excel,change minutes and seconds to seconds in excel,convert number in to seconds in excell,convert time to seconds in excel,converting minutes to seconds in excel,excel convert minutes to seconds,excel convert seconds to minutes and seconds,excel formula change minutes to seconds,excel formula to convert seconds to minutes,excel minutes,formula of minutes in excel,formula to convert seconds to time,minutes in excel,minutes toseconds excel,notation in seconds for excel,ph,add minues and seconds in excel,average minute formula in excel,average minutes and seconds excel,average minutes and seconds in excel,averaging minutes and seconds in excel spreadsheet,averaging seconds in excel,calculating seconds excel,calculating seconds in excel,can excel change from minutes to seconds?,chage excel en minutes et secondes,change min to sec in excel,change minutes and seconds to seconds on excel,change minutes to seconds on excel,convert 5 00 minutes to seconds?,convert 5 minutes in excel,convert minute to seconds excel,convert minutes and seconds seconds in excel,convert minutes to seconds formula



Related Excel Tips

Comments

Have another excel answer or questions for this problem ?
Feel free to post it here..