Go Back  British Expats > Living & Moving Abroad > Middle East > The Sand Pit
Reload this Page >

Looking for an Xcel Guru

Looking for an Xcel Guru

Old Jul 11th 2007, 12:45 pm
  #1  
Forum Regular
Thread Starter
 
ZIGGY2007's Avatar
 
Joined: Jul 2007
Location: Dubai
Posts: 42
ZIGGY2007 has a brilliant futureZIGGY2007 has a brilliant futureZIGGY2007 has a brilliant futureZIGGY2007 has a brilliant futureZIGGY2007 has a brilliant futureZIGGY2007 has a brilliant futureZIGGY2007 has a brilliant future
Default Looking for an Xcel Guru

Does anyone know in Excel what formula I can use to generate a time based schedule
Task -----how long---start time----finish time

1 ----------5 mins ----0900-------0905
2-----------75 mins 0905-------1020 etc etc time would keep rolling forward so finish time move to next task start time and keep going

Can't seem to get the time shift in a 24 hr clock basis
ZIGGY2007 is offline  
Old Jul 11th 2007, 12:52 pm
  #2  
Lost in BE Cyberspace
 
shakh your bootie's Avatar
 
Joined: Jan 2007
Location: By the old canal...
Posts: 7,715
shakh your bootie has a reputation beyond reputeshakh your bootie has a reputation beyond reputeshakh your bootie has a reputation beyond reputeshakh your bootie has a reputation beyond reputeshakh your bootie has a reputation beyond reputeshakh your bootie has a reputation beyond reputeshakh your bootie has a reputation beyond reputeshakh your bootie has a reputation beyond reputeshakh your bootie has a reputation beyond reputeshakh your bootie has a reputation beyond reputeshakh your bootie has a reputation beyond repute
Default Re: Looking for an Xcel Guru

Originally Posted by ZIGGY2007 View Post
Does anyone know in Excel what formula I can use to generate a time based schedule
Task -----how long---start time----finish time

1 ----------5 mins ----0900-------0905
2-----------75 mins 0905-------1020 etc etc time would keep rolling forward so finish time move to next task start time and keep going

Can't seem to get the time shift in a 24 hr clock basis
Not any easy one to answer in a post...

First of all, make sure that you have formatted the cells as "time" (right click on the cell or cells, choose format, then select time. You get a range of choices of how the time will be displayed).

Getting the cells to calculate correctly is a bit difficult to explain. Set up a row so that start time = previous rows finish time. Finish time = this rows start time + duration. Then use the autofill handle to copy that row as many times as you need to. Enter the durations and bob should be your proverbial..

If you get really stuck I'll knock one together for you & email it.

Finally, you might find that MS Project is a better tool for this job!
shakh your bootie is offline  
Old Jul 11th 2007, 1:26 pm
  #3  
Concierge
 
Blue Cat's Avatar
 
Joined: Feb 2007
Posts: 29,625
Blue Cat has a reputation beyond reputeBlue Cat has a reputation beyond reputeBlue Cat has a reputation beyond reputeBlue Cat has a reputation beyond reputeBlue Cat has a reputation beyond reputeBlue Cat has a reputation beyond reputeBlue Cat has a reputation beyond reputeBlue Cat has a reputation beyond reputeBlue Cat has a reputation beyond reputeBlue Cat has a reputation beyond reputeBlue Cat has a reputation beyond repute
Default Re: Looking for an Xcel Guru

Originally Posted by shakh your bootie View Post
Not any easy one to answer in a post...

First of all, make sure that you have formatted the cells as "time" (right click on the cell or cells, choose format, then select time. You get a range of choices of how the time will be displayed).

Getting the cells to calculate correctly is a bit difficult to explain. Set up a row so that start time = previous rows finish time. Finish time = this rows start time + duration. Then use the autofill handle to copy that row as many times as you need to. Enter the durations and bob should be your proverbial..

If you get really stuck I'll knock one together for you & email it.

Finally, you might find that MS Project is a better tool for this job!
I just love intelligent men
Blue Cat is offline  
Old Jul 11th 2007, 1:28 pm
  #4  
Lost in BE Cyberspace
 
shakh your bootie's Avatar
 
Joined: Jan 2007
Location: By the old canal...
Posts: 7,715
shakh your bootie has a reputation beyond reputeshakh your bootie has a reputation beyond reputeshakh your bootie has a reputation beyond reputeshakh your bootie has a reputation beyond reputeshakh your bootie has a reputation beyond reputeshakh your bootie has a reputation beyond reputeshakh your bootie has a reputation beyond reputeshakh your bootie has a reputation beyond reputeshakh your bootie has a reputation beyond reputeshakh your bootie has a reputation beyond reputeshakh your bootie has a reputation beyond repute
Default Re: Looking for an Xcel Guru

Originally Posted by Blue Cat View Post
I just love intelligent men
and i just love,err... blue rinsed-felines??? swalk.
shakh your bootie is offline  
Old Jul 11th 2007, 1:31 pm
  #5  
Concierge
 
Blue Cat's Avatar
 
Joined: Feb 2007
Posts: 29,625
Blue Cat has a reputation beyond reputeBlue Cat has a reputation beyond reputeBlue Cat has a reputation beyond reputeBlue Cat has a reputation beyond reputeBlue Cat has a reputation beyond reputeBlue Cat has a reputation beyond reputeBlue Cat has a reputation beyond reputeBlue Cat has a reputation beyond reputeBlue Cat has a reputation beyond reputeBlue Cat has a reputation beyond reputeBlue Cat has a reputation beyond repute
Default Re: Looking for an Xcel Guru

Originally Posted by shakh your bootie View Post
and i just love,err... blue rinsed-felines??? swalk.
oooh!!! I gone weak at the paws!
Blue Cat is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Contact Us Archive Advertising Cookie Policy Privacy Statement Terms of Service

Copyright © 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.