Hi...

I want the value of a cell to represent 45 hours... so that I can refer to this cell as a fixed amount of time that I can then use in a formula.

for example, if I want to know what the time is + 45hrs.

Eg: In cell A1 I have value "24/12/2014 12:00", and the cell formatted to display (dd/mm/yyyy hh:mm)

I want cell A2 to hold the value of "45 hours" ...

In cell A3 I want to have the simple formula: =A1+A2 ... that will then return the result "26/12/2014 09:00" ... ie 24/12/2014 12:00 + 45hrs.

Can anybody help?