Thread: adding time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default adding time

The values have to be in the same format, so if you have 8:25:00 in A1
and 40 in B1, you need this in C1:

=A1+B1/24/60

and format the cell as [h]:mm to see 9:05.

Hope this helps.

Pete

On Mar 28, 7:15*pm, behind the counter person
m wrote:
I am trying to get a function that will add time. *Example 8:25 + 40 mins=
Any suggestions?