Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding/subtracting # of hours from a time | Excel Discussion (Misc queries) | |||
Adding hours to time in Excel | New Users to Excel | |||
Adding a decimal hours to a starting time to give a finishing tim | Excel Discussion (Misc queries) | |||
Adding time HH:MM when it addds up to more than 24 hours | New Users to Excel | |||
Adding time in hours | Excel Discussion (Misc queries) |