Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 52
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,718
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
adding/subtracting # of hours from a time HRobertson Excel Discussion (Misc queries) 5 July 12th 07 04:06 PM
Adding hours to time in Excel [email protected] New Users to Excel 6 May 11th 07 10:50 PM
Adding a decimal hours to a starting time to give a finishing tim Peter Rooney Excel Discussion (Misc queries) 3 March 21st 07 02:48 PM
Adding time HH:MM when it addds up to more than 24 hours Smudge New Users to Excel 8 August 30th 06 03:41 AM
Adding time in hours Jono Excel Discussion (Misc queries) 2 September 22nd 05 12:46 PM


All times are GMT +1. The time now is 01:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"