I'm new to this forum, but I can seem to get it figured out. I've tried and I keep getting 8:17, so not 8:10 which makes no sense to me. If anyone can help i'd appreciate it!
I'm new to this forum, but I can seem to get it figured out. I've tried and I keep getting 8:17, so not 8:10 which makes no sense to me. If anyone can help i'd appreciate it!
Please upload the workbook. It's by no means clear what you have entered.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
with format m:s should give the right result.Formula:Please Login or Register to view this content.
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
Try this
in B1 and copy down
=--SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"h",":"),"m",":"),"s","")," ","")
Format Custom, [h]:mm:ss
Row\Col A B 10h 8m 0:08:00 20h 8m 10s 0:08:10 355h 5m 55:05:00 432h 32:00:00 545h 25m 45:25:00 655h 5m 55:05:00 725h 50m 25:50:00 899h 20m 99:20:00 90h 8m 0:08:00 100h 8m 10s 0:08:10
Last edited by AlKey; 05-29-2015 at 05:21 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you that worked. Is there any way to remove the 0 before the 08? so it shows 08:10 rather than 0:08:10
You would have to change formatting for this. If there are only minutes and seconds you can format Custom, m:ss
If you issue has been resolved please don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks