| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to give date and time
Hi Everyone!!
Looking for help on a formula. I have s apreadsheet In Column A is a date and time 12/04/07 16:00 In column B I need to have a formula to add 4 hours to column B but..... this is the difficult part that I am not sure is possible....... this formula needs to take in to account days and times - 9am - 5pm Monday - Friday. So I need 12/04/0716:00 With formula of 9am-5pm would be 13/04/07 12:00 Any help would be great Any questions please ask. Thanks everyone |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a decimal hours to a starting time to give a finishing tim | Excel Discussion (Misc queries) | |||
| Give RELEVANT responses to questions. DO NOT give usless list | Excel Worksheet Functions | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
| I need to measure hours between two events(time/date) to give me . | Excel Worksheet Functions | |||
| Give File Time to update Pivot Table when started bij Macro | Excel Discussion (Misc queries) | |||
Threaded Mode
