Adding hours to a time
=B2+B3/24
"ordnance1" wrote:
In cell B2 is a time (the cell is formated hh:mm). In cell B3 is the number
of hours I want to add
In this example in cell B2 is 06:00, in cell B3 is 11 (the number of hours I
want to add) which should return 17:00.
I can not seem to get this to work.
|