Adding hours to a time
 

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.

Adding hours to a time
 

You have to convert the decimal number 11 into a time value.

Try it like this:

=B2+(B3/24)

Format as [h]:mm

--
Biff
Microsoft Excel MVP


"ordnance1" wrote in message
...
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.

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.