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) |