LinkBack URL
About LinkBacks
Hi all,
I have various times in a spreadsheet such as "100842" minutes which I need to convert to days hours and minutes. I am fairly open as far as presentation, I could use ddd:hh:mm or something similar.
I appreciate any help offered!
Hi all,
I have various times in a spreadsheet such as "100842" minutes which I need to convert to days hours and minutes. I am fairly open as far as presentation, I could use ddd:hh:mm or something similar.
I appreciate any help offered!
More examples of source data and desired results would be helpful.
Meanwhile,
With
A1: (a number intended to convey days, hours, and minutes.....eg 100842)
This formula presents the components of that number, separated by colons (
In the above example, 100842 displays as 10:08:42
Please Login or Register to view this content.
Is that something you can work with?
How about?
=INT(A1/1440)&" days "&INT(MOD(A1/1440,1)*24)&" hours "&INT(MOD(MOD(A1/1440,1)*24,1)*60)&" minutes"
where A1 contains original number of minutes.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
I guess I took 100842 to be a total amount of actual minutes....
NBVC,
Works beautifully, thanks a bunch!
NBVC
...and I (mistakenly?) thought it was a number to be broken into segments.
I think you got right.
If it is the total number of minutes...perhaps this approach:
With
A1: 100842
returns: 70:00:42Please Login or Register to view this content.
or...
returns: 70 days 00 hrs 42 minPlease Login or Register to view this content.
I guess we'll see if we helped (one way or the other)
Hi
Just continuting on from the previous query.
Once you got the answer - displaying number of days, hours and minutes
How can you change that to display in tota hh:mm format?
I have tried to do the same for 3900 minutes-
I get 2 days 17 hours and 0 minutes.
But now I want to display this 2days and 17 hours as 65:00
Is there any way this can be done?
=text(a1/1440,"[h]:mm:ss")
try the abovePlease Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Tulsip welcome to the forum
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks