| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Formulas
I formatted column A Time A3- 6:00am A4- I need a formula that = A3+30 minutes. So I can fill the rest of the rows quickly. I tried several guesses but I give up. It must be easy if you know it.:) -- famdamly ------------------------------------------------------------------------ famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382 View this thread: http://www.excelforum.com/showthread...hreadid=517906 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Formulas
Sorry I double posted. This question was already answered. I couldn't find the post. -- famdamly ------------------------------------------------------------------------ famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382 View this thread: http://www.excelforum.com/showthread...hreadid=517906 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Formulas
"famdamly" wrote in
message ... I formatted column A Time A3- 6:00am A4- I need a formula that = A3+30 minutes. So I can fill the rest of the rows quickly. I tried several guesses but I give up. It must be easy if you know it.:) A4 =A3+1/48 would do. Times are in fractions of a day. -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to calculate Date & Time differences | Excel Worksheet Functions | |||
| Time and motion chart | Charts and Charting in Excel | |||
| Can series tool change formulas over time when used to copy them | Excel Worksheet Functions | |||
| Time Sheets | Excel Discussion (Misc queries) | |||
| formulas for employee time sheets | Excel Worksheet Functions | |||
Hybrid Mode
