Link to home
Create AccountLog in
Avatar of John Darby
John DarbyFlag for United States of America

asked on

Excel - create gantt time chart from 4 columns of dates & times

Attached is a doc with 4 colums
C1 - Start date
C2 - End Date
C3 - Start Time
C4 - End Time

I am recording time in 15 minute increments for a deployment plan and would like to fill in the cells in each row according to the date and time data in the 4 columns. There is a 15-minute increment across the the top (x-axis). Can you help me understand how to have cells in this spreadsheet "fill in" based upon the time/date data?

Any help is appreciated!

Thank you, in-advance!
JohnD
TaskTimes.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of John Darby

ASKER

Thank you teylyn! This is so straightforward; much appreciated! :)