Using time formula to create a master schedule

I am trying to create a sheet with a formula that calculates total time worked in a day, from a start time to an end time. I want to show who is working in specific units, from 8:30am to 7pm, at 30 minute increments for a 18 week period.

See my pdf mock up attached. I created it in Excel.

Any help would be a big help!

Jeffrey

Find more posts tagged with

Calendar View

Education

Formulas

Attachments

Comments

J. Craig Williams

Jeffrey,

PDF's are not supported at images here.

Smartsheet does not handle time well. You can set up something using dropdowns for the start & end time and then parse out the results, but you can't use the Start / End Dates from the project settings.

It can and has been done.

Craig