| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time
I am attempting to create a form/spreadsheet that will add time to an
original time. For example we have 1145 as a start time. I have task to accomplish @ 15 minutes, 30 minutes, 1 hour, 1.5 hours. Can someone please help me with this. Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time
Assume A1 is the true Excel time 11:45 AM
To add those time increments: =A1+TIME(0,15,0) =A1+TIME(0,30,0) =A1+TIME(1,0,0) =A1+TIME(1,30,0) -- Biff Microsoft Excel MVP "MarcRN" wrote in message ... I am attempting to create a form/spreadsheet that will add time to an original time. For example we have 1145 as a start time. I have task to accomplish @ 15 minutes, 30 minutes, 1 hour, 1.5 hours. Can someone please help me with this. Thank you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time
A1 = start time
=A1+TIME(0,15,0) If this post helps click Yes --------------- Jacob Skaria "MarcRN" wrote: I am attempting to create a form/spreadsheet that will add time to an original time. For example we have 1145 as a start time. I have task to accomplish @ 15 minutes, 30 minutes, 1 hour, 1.5 hours. Can someone please help me with this. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| straight time, time and a half, and double time | Excel Discussion (Misc queries) | |||
| Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
| Subtracting Dates to get total time work time excluding weekends | Excel Discussion (Misc queries) | |||
| verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Linear Mode
