I need a formula please to add the following time values and get the shown result :
19442:46 + 33:14 = 19476:00.
I need a formula please to add the following time values and get the shown result :
19442:46 + 33:14 = 19476:00.
A simple addition will do this.
=A1+B1
Use the same formatting on your result as for the first two numbers, which is probably [h]:mm.
Excel regards time values of 10,000 hours or more as text values (although it can give you a valid calculation result > 10,000 hours), so you need to split the larger time in two or more time value < 10,000 hours, e.g.
="9999:00"+"9443:46" +"33:14"
Put that in a cell, format as [h]:mm and you'll see 19476:00
or you can do similar with the time values in cells, if you want it that way
Audere est facere
I did that already, unfortunately I got a #VALUE! as a result!
See my previous reply - you need to split up the times in to values less than 10,000 hours for Excel to recognise them as times
See Excel specifications and limits
https://support.office.com/en-gb/art...rs=en-GB&ad=GB
last entry in Calculation specifications and limits
While other items have increased, e.g. number of nested functions allowed, Largest amount if time that can be entered has remained at 9999:59:59 for as long as I remember
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks