Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 13, 2018 05:46 AM
I am looking for a simple formula to compute hours worked. I have “Start Time” and “End Time” and am looking for a formula for “Total Hours Worked”. I tried one of the other formulas that I found on another post and was unable to get it to work with my table. If someone could provide me with a simple formula to add my start time and end time and output a total hours worked I would appreciate it!
Apr 15, 2018 05:44 PM
I’ll update it in a few minutes and let you know
Apr 15, 2018 06:04 PM
Ok, refresh it and take a look - I updated it to give you the ability to enter a date to override the automatic dating of “Today” if you need to enter times from a different day. Again, you can hide any formula fields you don’t need to see.
Does that work? Anything else you’d need this to do?
Apr 15, 2018 06:31 PM
Works perfectly thanks so much!
May 29, 2019 11:11 AM
Hi there, please would you be able to adjust this so that it works for night shifts? so for example, 7pm to 7am is a shift. Or could you please tell me how to do it. Thank you very much.
Jan 03, 2022 02:12 AM
Hi Jeremy, this is so helpful. Can you let me know how I format the first columns to have european format of Dates? Thanks, Nadine
Jan 03, 2022 07:26 AM
If you are referring to the formula fields, you can use these specifiers with the DATETIME_FORMAT function to get just about any format you could want:
So, for example, you could do:
DATETIME_FORMAT({My Date}, 'YYYY-MM-DD')