Weekly Timesheet Possible?

Good Morning

I would like to create an online form for our employees to be able to enter a weekly timesheet. Each day employees could be at a different site ( or multiple sites) so I thought id structure the columns as below ( 10 spots for entry with the following columns for each entry.

/Project Number 1 / Date 1 / Start Time 1 / Finish Time 1 / Hours on Project 1 /

I would like to be able to calculate the hours on each project (10 data entry spots for the user [Start Time and Finish Time 1 through 10] and 10 ten time calculations [Hours on Project 1 throuh 10] on a row) and then sum the hours for the weekly total. ( that bit should be easy)

On the form for the user, they would not see the time calculation areas. Just the start and finish times and a date

Any help with this query would be greatly appreciated. From what i have read on the forums the formulas are complicated and can be hard to adapt?

Find more posts tagged with

Accepted answers

All comments

Intern98

Hi,

The time format must be in Integer form, example

1000, 0900, 2000

SS recognizes '10:30' as a string and calculation would not be possible.

with time in 24hr format, 0000, 0100, 0900.

You can use =(([End Time X]@row-[Start Time X]@row)/100) , for hours in proj X

sum of total , =SUMIF([Hours in proj 1]@row:[hours in proj 10]@row, <=14) , assuming no one works more than 14hrs each shift

Andrée Starå

Hi @Ashazaur

I hope you're well and safe!

To add to Intern98's excellent advice/answer.

There are ways to make the format HH:MM work.

Look at this excellent thread from Paul that has many different Time solutions.

https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.