# 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?

• ✭✭✭
edited 03/29/22

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

• ✭✭✭✭✭✭

I hope you're well and safe!

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

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

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!