If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
add 10,0015:15 hours to 03:53 Hours to a total time
when adding a hour number larger that 10,000 to another time number the
formula will not give a correct answer. Tried several time formats and nothing worked. I need a format that is (HH,HHH:MM). |
#2
|
|||
|
|||
add 10,0015:15 hours to 03:53 Hours to a total time
Unfortunately 10,000 hours is an Excel limit, you have to find a workaround
for handling greater number of hours (e.g. work with plain numbers). Regards, Stefi „Alan” ezt *rta: when adding a hour number larger that 10,000 to another time number the formula will not give a correct answer. Tried several time formats and nothing worked. I need a format that is (HH,HHH:MM). |
#3
|
|||
|
|||
add 10,0015:15 hours to 03:53 Hours to a total time
As Stefi mentioned, you've run into a type of limit. XL doesn't recognize
"10000:15" as being a time value. However, you can do the mathematical equivalent of ="3:00"+10000/24+15/(24*60) with the middle term being your hours and last term being minutes.To get the format you desire, you'll have to *fake* it, and use a formula similar to: =TEXT(INT(A2*24),"#,###")&":"&MINUTE(A2) where A2 is the cell containing previous formula. the problem with this is you now have a text string as opposed to a number. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Alan" wrote: when adding a hour number larger that 10,000 to another time number the formula will not give a correct answer. Tried several time formats and nothing worked. I need a format that is (HH,HHH:MM). |
#4
|
|||
|
|||
add 10,0015:15 hours to 03:53 Hours to a total time
Add it in two stages, 5000 and then another 5000.
-- __________________________________ HTH Bob "Alan" wrote in message ... when adding a hour number larger that 10,000 to another time number the formula will not give a correct answer. Tried several time formats and nothing worked. I need a format that is (HH,HHH:MM). |
#5
|
|||
|
|||
add 10,0015:15 hours to 03:53 Hours to a total time
Even in ne formula it works
=K2+"5000:00:00"+"5000:00:00" -- __________________________________ HTH Bob "Bob Phillips" wrote in message ... Add it in two stages, 5000 and then another 5000. -- __________________________________ HTH Bob "Alan" wrote in message ... when adding a hour number larger that 10,000 to another time number the formula will not give a correct answer. Tried several time formats and nothing worked. I need a format that is (HH,HHH:MM). |
#6
|
|||
|
|||
add 10,0015:15 hours to 03:53 Hours to a total time
The largest time value that can be *manually* entered in a cell is
9999:59:59. You can use formulas to return much higher time values, though. So, you'd need to split your time into 2 cells: A1 = 5000:00 A2 = 5000:00 A3 = 3:53 =SUM(A1:A3) Returns 10003:53 -- Biff Microsoft Excel MVP "Alan" wrote in message ... when adding a hour number larger that 10,000 to another time number the formula will not give a correct answer. Tried several time formats and nothing worked. I need a format that is (HH,HHH:MM). |
Thread Tools | |
Display Modes | |
|
|