Question on how to show 80hrs in a cell ? using =time(x,x,x)

According to the help file (https://support.microsoft.com/en-us/...e-747d0b8d5457 ) TIME() cannot return a value greater than 1 day. When you put 80 in the hours argument, Excel divides by 24 (80/24=3 days 8 hours) and returns only the remainder -- the 8 hours part.

In order to get something representing 80 hours, you will need to enter using something other than the TIME() function. I can enter 80:00:00 and Excel and it will recognize this as 80 hours (3 1/3 days). If you can convert the number of hours to days (the basic unit of Excel's date time serial number system), then you can enter that -- so 80 hours could be entered as 3 1/3 or 3.3333333333 or similar. You could use the CONVERT() function (or equivalent) =CONVERT(80,"hr","day").

Several options, but just know that you cannot use the TIME() function for times larger than 1 day.

@northernwarrior.... You can simply write 80:0 into a cell formatted as Custom [h]:mm, or "80:0" with double-quotes in a numerical expression (e.g. A1-"80:0").

Use the numerical expression --"80:0" or VALUE("80:0") -- not TIMEVALUE -- if you need the constant to stand alone, for example as parameter (e.g. VLOOKUP(--"80:0", A1:B100, 2, TRUE)).

That form works as input for times up to 9999:59:59.999 (416 days 15h 59m 59.999s).

I say "as input" because the format [h]:mm:ss.000 can display a longer range of time, up to 71003183:59:59.999. That is 2958465 days 23h 59m 59.999s, where 2958465 is the serial number for 12/31/9999, the largerst date that Excel formats with a date or time format.