Hi Folks,
It's my first loggin and I'm trying to convert numbers to time (900 to 9:00 and 1118 to 11:18). I have tried (=TEXT(K8,"HH:MM") or (=TEXT(K8/24,"hh:mm") but it's not working. I'll appreciate any help.
Thank you!
Henrique.
New Excel Forum
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
|
|
Unlocking the Mysteries of Excel
|
Convert numbers to time
2 posts
• Page 1 of 1
Re: Convert numbers to time
by Sisyphus » Thu Dec 22, 2011 9:17 am
Hi,
This formula will do the conversion of a number in B4:
The result will appear differently, depending upon the formatting you choose for it.
Enjoy your day!
This formula will do the conversion of a number in B4:
- Code: Select all
=TIME(B4/100,MOD(B4,100),0)
The result will appear differently, depending upon the formatting you choose for it.
Enjoy your day!
- 0
Have a great day!
Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
- Sisyphus
- Former Moderator
- Posts: 4454
- Joined: Dec 7, 2011
- Location: Shanghai
- Reputation: 203
- Excel Version: 2010
2 posts
• Page 1 of 1
Return to General Excel Questions
Who is online
Users browsing this forum: No registered users and 243 guests