| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add 15 minutes
On Tue, 10 Jan 2006 22:18:56 -0500, "Jaye" wrote:
I would like a formula to add 15 minutes to a column of times formatted as: h:mm:ss AM/PM, so if: A1 were equal to 5:00:00 PM, I would like a formula for B1 to produce 5:15:00 PM. =A1+time(0,15,0) --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding hours and minutes | Excel Worksheet Functions | |||
| Using military time but with 100 minutes not 60 minutes | Excel Discussion (Misc queries) | |||
| adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
| AutoSave: How can I get it to save every 5 minutes & NO prompt? | Excel Worksheet Functions | |||
| convert hours and minutes to minutes | Excel Discussion (Misc queries) | |||
Hybrid Mode
