Not sure where your number are coming from. I used

=TIMEVALUE("00:26:35")

The results is 0.018461 which equals

26/(24*60) + 35/(24*60*60)


Time values is in Hours:Minutes:Seconds.

1 hour = 1/24 since a day equals 1.00

1 Minute = 1/(24*60) 24 hours/day * 60 minutes/hour

1 Second = 1/(24*60*60) 24 hours/day * 60 minutes/hour * 60 seconds/minute




which gives

"Paul" wrote:

Hi

I have decimal numbers that need to be converted to times eg 18.76 = 18 mins
46 seconds using the text formaula but I have 26.35 that equals 2.21. Why can
anyone help?