I have a column (Time) which combines two other columns (Hours and Minutes).
TIME
-0.44
-0.27
0.49
-0.06
2.43
7.52
-1.02
8.65

My results come back with a "." instead of a ":". These numbers are in this format "hh.mm". The numbers after the decimal (7.52 for example) are not fractions of hours, but actual minutes (7 hours and 52 minutes). I need to be able to add up these times and show them in the format "hh:mm".
I dont want it to return 8.65, but 9:05 instead.
I have trouble adding "negative" times. Can this be done in Excel?

Is there any way to do this?!?

TIA,

DejaVu