Hello friends, I need to ask for another favor from you guys:
when I sum up a time in a cell, I want to display it as this (for example): "10 Hours 17 Minutes"
I can't manage to display these words (Hours and Minutes) in the cell. What should I write in the custom formula bar?
Not completely as you want but almost there. Try in Custom Format.
h hou\rs & mm mi
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Try this custom format
h" Hours "mm" Minutes"
Life's a spreadsheet, Excel!
Say thanks, Click *
hi,
select the cell you want to change the time format as you want and go to format cells option and go to custom and type
h" hour " mm "minutes"
and click ok
regards,
sathya
worked while using "" thanks guys, first I entered wrong "" symbols and it did not work.
Hi You can use below formula
=HOUR(SUM(C3:C5))&"Hours(s) "&MINUTE(SUM(C3:C5))&"Minute(s)"
cell format should be general (i have considered data in cell C3 to C5)
Click on * below if you find this helpful
Thanks,
A
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks