Simple Hours Worked Formula

[Kate_Linkosky]

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!

[Jeremy_Oglesby]

I’ll update it in a few minutes and let you know

[Jeremy_Oglesby]

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?

[Kate_Linkosky]

Works perfectly thanks so much!

[crrne]

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.

[Nadine_Binias]

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

[Jeremy_Oglesby]

Hi @Nadine_Binias

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:

Airtable Support

Supported format specifiers for DATETIME_FORMAT

The DATETIME_FORMAT function will allow you to reformat the data from the date-type field into a string of your specifications. This is written in the format of DATETIME_FORMAT(Datetime, 'format sp...

So, for example, you could do:

DATETIME_FORMAT({My Date}, 'YYYY-MM-DD')