| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating Time Schedule in Excel
Hi!
I'm having proplems with creating schedule: 1st task Start time - (will be given in HH:MM format) 1st task Duration - (will be given in MM format) 1st task Finish time - (need to find in HH:MM format) 2nd task Start time = 1st task Finish time 2nd task Duration - (will be given in MM format) 2nd task Finish time - (need to find in HH:MM format) etc. I really appreciate any help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating Time Schedule in Excel
If your duration is actually in mm format, it's simple addition, as in:
a1=start time, a2 = duration a3=a1+a2 If your duration is actually in number of minutes, then use: a3=a1+a2/1440 Regards, Fred "dmitry" wrote in message ... Hi! I'm having proplems with creating schedule: 1st task Start time - (will be given in HH:MM format) 1st task Duration - (will be given in MM format) 1st task Finish time - (need to find in HH:MM format) 2nd task Start time = 1st task Finish time 2nd task Duration - (will be given in MM format) 2nd task Finish time - (need to find in HH:MM format) etc. I really appreciate any help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a schedule | Excel Discussion (Misc queries) | |||
| Creating a schedule | Excel Discussion (Misc queries) | |||
| Creating a Schedule | Excel Discussion (Misc queries) | |||
| Creating a schedule | Excel Worksheet Functions | |||
| Creating Machine shop part schedule using Excel | Excel Discussion (Misc queries) | |||
Linear Mode
