LinkBack URL
About LinkBacks
Hi,
I have a list of times in dd:hh:mm format. For example: 02:17:23 for 2 days, 17 hours and 23 minutes.
How do I convert this into a number/decimal format for hours only?
Thanks in advance for any help!
Hi,
I have a list of times in dd:hh:mm format. For example: 02:17:23 for 2 days, 17 hours and 23 minutes.
How do I convert this into a number/decimal format for hours only?
Thanks in advance for any help!
Try =24*(LEFT(A1,2) + MID(A1,4,5))
Entia non sunt multiplicanda sine necessitate
No, that doesn't work.
Is the data text, or date/time? If it's text then shg's solution should work. If it's date/time then it is being stored as "days since January 1 1900". Date/time in Excel is a floating point number in units of days. To get hours just multiply by 24:
=INT(A1)*24
It works for your example, returning 65-odd hours, does it not?
I tried it for the example formatted as a text string and it works. If the example is 2.724305 custom formatted as "dd:hh:mm" then it does not work, and multiplying by 24 works.Originally Posted by shg
So the OP needs to specify just what the data is.
i dont see how you could use a date to represent a number of days,how would you get more than 31 days if it was a date number ?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Good point, this approach does not work if you go over 31:59:59. All the more reason that namip needs to come back and tell us the details.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks