TIME function produces incorrect results

[Jim_Robison]

I am using =TIME(h,m,s). Excel seems to only use the integer portion of the input. For example, =TIME(1.75,0,5.9999) should output 1:45:06 but is the outputs 1:00:05 instead. My input is actually coming from three other cells, where I can use the ROUND functions for each of the three input variables, but it's frustrating that the Excel TIME function can't handle decimal input. Further, I see no caution about this constraint in the official Excel "Help on this formula" section. Any ideas?

[AliGW]

I've never known anyone who's wanted to use decimals with the TIME function!

Why don't you just add the values together and weight appropriately?

For example, if A1 contains hours, A2 minutes and A3 seconds:

=(A1/24)+(A2/60/24)+(A3/60/60/24)

Format the output cell as time.

Excel 2016 (Windows) 32 bit

	A	B	C
1	1.75		01:45:06
2	0
3	5.9999

Sheet: Sheet1

[etaf]

EDIT
you have a reply suggesting the same as my post, arrived while i was typing

you have 3 cells , 1st providing time as a decimal number 1.75 in your example
2nd is providing the minutes - but in what format, is this also decimal so includes seconds - so is 1.75 here 1 min and 45 seconds
3rd value is providing seconds
perhaps give a few more examples - I think you would need to convert the decimal time into hours mins and seconds for each of the the 3 cells and add them together

maybe a simpler solution, someone else may answer - but thats how i think i would do it

TIME( HOURS() , .....
Not fraction of hours