Question description:
This user has given permission to use the problem statement for this
blog.
How can you change duration in hh:mm:ss to dd:hh:mm:ss (if hh exceeds 24 hours?)
Solved by A. F. in 9 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
12/06/2018 - 11:58
Hello
Excelchat Expert
12/06/2018 - 11:58
Welcome to excelchat, we are glad to have you with us todya.
User
12/06/2018 - 11:58
Hi!
User
12/06/2018 - 11:59
Do you know how I can change duration in hh:mm:ss to dd:hh:mm:ss (if hh exceeds 24 hours?)
Excelchat Expert
12/06/2018 - 11:59
Yeah, Please give me a few minutes.
User
12/06/2018 - 11:59
Sure
Excelchat Expert
12/06/2018 - 12:00
Can you please input 2/3 sample in column A?
User
12/06/2018 - 12:02
so i'd like a2 to be displayed as 01:12:00:00
User
12/06/2018 - 12:02
instead of 36;00:00
Excelchat Expert
12/06/2018 - 12:03
Please look at column C.
Excelchat Expert
12/06/2018 - 12:03
It has also converted 24:00:00 to 1 day.
Excelchat Expert
12/06/2018 - 12:04
The formula for C2 is =INT(A2)&":"&TEXT(A2,"hh:mm:ss")
Excelchat Expert
12/06/2018 - 12:04
Does this work?
User
12/06/2018 - 12:05
I feel so stupid right now
User
12/06/2018 - 12:05
Thanks!
Excelchat Expert
12/06/2018 - 12:05
Ah, we all do tend to forget easy things time to time.
Excelchat Expert
12/06/2018 - 12:06
I'm just glad to be able to help you out.
Excelchat Expert
12/06/2018 - 12:06
Do you have any question?
User
12/06/2018 - 12:06
Nope, just needed that formula
User
12/06/2018 - 12:06
i remember now
Excelchat Expert
12/06/2018 - 12:06
Great.
Excelchat Expert
12/06/2018 - 12:06
The session will end in 11 minutes unless you opt to end it before.
Excelchat Expert
12/06/2018 - 12:07
I would love if you can rate my service once the session ends.
Excelchat Expert
12/06/2018 - 12:07
Thanks and have a great day!
User
12/06/2018 - 12:07
Thanks, you too!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.