New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Time Settings

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Time Settings

Postby RoseApio » Thu Apr 07, 2016 12:34 am

Hey all,
i need some help. I have a big document with time written as 7.45 meaning 7:45, I need to to change it into the hh:mm:ss but when I try, the times just change to 00:00:00, what can i do if i want it as 07:45:00.
  • 0

RoseApio
Rookie
 
Posts: 1
Joined: Apr 7, 2016
Reputation: 0
Excel Version: 2010

Re: Time Settings

Postby Kevin UK » Thu Apr 07, 2016 1:02 am

One quick way and assuming your data is in A1.

Code: Select all
=--SUBSTITUTE(A1,".",":")
  • 0

Regards

Kevin
Kevin UK
Excel Master
 
Posts: 568
Joined: Jun 24, 2012
Reputation: 86
Excel Version: 2016


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 80 guests

cron