Start time before 8AM

Gina Prego
Gina Prego ✭✭✭
in Formulas and Functions

I am using duration column in increments of e10m, e30m, etc. But I cannot get my start time before 8AM. I want my working hours to be 5AM - 10PM. How do I do this without making it a 24 hour clock?

· Share on FacebookShare on Twitter

Answers

  • J Tech
    J Tech ✭✭✭✭✭

    If you go into your project settings you can adjust your length of day to be a certain number of hours. Is that what you mean?

    Regards

    J Tech

    If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!
    · Share on FacebookShare on Twitter
  • Gina Prego
    Gina Prego ✭✭✭

    If I adjust the length of day the time still starts at 8AM, the end time becomes longer. I need to adjust the working hours so my start time can be 5AM

    · Share on FacebookShare on Twitter
  • Ilker Uyanik
    Ilker Uyanik ✭✭

    I had the same problem. I like to show tasks that are supposed to start the next day starts 9:00 AM in the plan because the company uses CST and employees begin to work at 9:00 AM.

    Lacking this feature makes SMARTSHEET useless as a minute-by-minute planning tool.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!