I know how to show (concatenate) the result of two cells. However, if the contents of the cells is in date-time format this seems harder.

I have a list of how many hours I worked on something per week over a period: 8 6 16 18 12 24 36 24 12. I want do display the min, and max. amount of hours I did (so far easy). I wish to show that in a single cell: “6-36” (with the unit for that column the absolute number of hours).

I have only been able to get the results shown as fraction of days, ie. “0.25-1.5”.

I tried converting the numbers with the TEXT function, but that gives an error. Seemingly it won’t work with date-time because those aren’t simple numbers. I haven’t found a DATETIME function that would return the right number.

Note that one issue in this is wanting absolute hours ([HH]), which I then use as a normal number, but wanting to keep them as a time-value so I can enter fractions of an hour in minutes (and not wanting to wrap after 24 h, hence [HH], not HH as a unit).