| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding time
I am trying to get a function that will add time. Example 8:25 + 40 mins=
Any suggestions? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
adding time
Maybe
08:25 in a1 =A1+TIME(0,40,0) Mike "behind the counter person" wrote: I am trying to get a function that will add time. Example 8:25 + 40 mins= Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding time | Excel Worksheet Functions | |||
| adding time | Excel Discussion (Misc queries) | |||
| Time log adding time from separate sheets | New Users to Excel | |||
| Adding Time | Excel Worksheet Functions | |||
| Adding time to date-time formatted cell | Excel Discussion (Misc queries) | |||
![behind the counter person[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
